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?
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.
Hello Jason, The formula in Sheet1!E2, copied down to Sheet1!E4 is: =LOOKUP(PI(), 1/((Sheet2!A2:A6=--F2)*(Sheet2!H2:H6=K2)), Sheet2!G2:G6) F2 is left-aligned, which indicates that Excel reads it as text. The double unary (--) before F2 converts the text value of F2 to number.
Best Response confirmed by
jasonm69 (New Contributor)