google sheets – find matching data in two tabs and pulling data into new cell

I couldn't find an answer to this so I appreciate anyone's time to share some guidance.

I have a 3 tab sheet and trying to do develop the following formulas (all are in tab 1 of sheet):

IF tab1 row2 cols A&B are found/matched anywhere in tab2 cols A&B, THEN display tab 2 col D data (of the row it's found in) here

IF tab1 row2 col D is found anywhere in tab2 col D, THEN display tab 2 col C data (of the row it's found in) here

IF tab1 row2 col D is found anywhere on tab3 col A, THEN display tab 3 col B data (of the row it's found in) here

I greatly appreciate anybody's guidance on this....



Read more here: https://stackoverflow.com/questions/68475791/google-sheets-find-matching-data-in-two-tabs-and-pulling-data-into-new-cell

Content Attribution

This content was originally published by Phendyr at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: