Mar 01 2019 03:31 AM - edited Mar 01 2019 05:40 AM
I have a workbook with multiple sheets. I want to basically use 2 columns worth of data from sheet 1, match it to the same data on sheet 2, and then return the value in a third column on sheet 2, in the neighbouring cell on sheet 1. I've tried many different equations without success. Can anyone help me?
Mar 01 2019 07:42 AM
Mar 04 2019 12:51 AM
Hi Twifoo
I've attached below the example of data that I need to create this formula for. What I need is a formula that looks at cell F2 & K2 on sheets 1, finds the exact match on sheet 2, which in this example would be line 2 on sheet 2. Then I need the formula to use the information in cell G2 on sheet 2 and put that data into cell E2 on sheet 1.
I hope I have explained this in enough detail. Thanks for your help.
Mar 04 2019 02:02 AM
SolutionMar 04 2019 02:02 AM
Solution