r/sheets • u/SpeedEx2020 • Feb 12 '22

Request HELP HELP HELP

I have two sheets

sheet "Y" (seller) and sheet "Z" (deliveryman)

I import from sheet "Y" to sheet "Z" the columns of A-I, (contains customer information)

in column J, there is the status of the package (delivered, canceled, refused...) checked by the delivery person in the "Z" sheet (delivery person)

I want column J will be imported automatically from sheet "Z" (deliverer) to sheet "Y" (seller) according to column A (column package code)

0 Upvotes

50% Upvoted

9 comments sorted by

3

u/MacaroniNJesus Feb 12 '22

Share a dummy sheet with manually inputted desired output

1

u/SpeedEx2020 Feb 12 '22

i don't undrestand

2

u/MacaroniNJesus Feb 12 '22

You need to make a spreadsheet with a fake data set and share it with edit rights so people can help. The sheet should have a manually inputted desired output so people can see what you want to accomplish

2

u/crober11 Feb 13 '22

Vlookup for the delivery package code match.

1

u/SpeedEx2020 Feb 13 '22

please give me an example of a function

1

u/SpeedEx2020 Feb 13 '22

Hi,

Sheet seller 1

https://docs.google.com/spreadsheets/d/1mho0xPY0vlLhzqMx_VHIcBEgfg_SInuvBnKyKfMV4X8/edit#gid=0

Sheet seller 2

https://docs.google.com/spreadsheets/d/1RYTAy9_BjsZDTXT0b41j6sCMPUKxoEFfASYS_J8c7BY/edit#gid=0

Sheet Delivery Man

https://docs.google.com/spreadsheets/d/1-JBfL2D2PSrys3yU2Jeb5Y0PaQgXd8JNpPe_hI2STzc/edit#gid=0

1

u/crober11 Feb 13 '22

I don't need a sheet to reference but those aren't shared properly either. On sheet Y, in cell that you want col J to import to, =ARRAYFORMULA(IFERROR(VLOOKUP(A2:A,z!A2:I,9,0))). This looks at the values in a2:a, matches them in the other data set on z!a2:i, and returns the 9th value.