I have a very basic knowledge of deeper functions of Google sheets and solving this has been a little bit of pain in the butt so far.
I have a spreadsheet A
- column A contains ID
- column I that has the info that I need to receive
I have spreadsheet B
- in my column X I need to get the exact data that is in spreadsheet A, column I
the thing is these two spreadsheets don't have the same order of IDs so basically I need it first look for the correct ID, THEN to duplicate data into my spreadsheet B, column X. Column A in both sheets contain IDs, just assorted compared to each other.
Hopefully, this explanation is understandable enough.