Good Morning Everyone,
I need to Match the column in worksheet2 to a column in worksheet1 then match the row in the worksheet2 to a row in the worksheet1 and index the value in the corresponding column/row of the worksheet1.
I’m certain I need to apply the MATCH and INDEX and probably the OFFSET but my logic doesn’t appear to be working so well. Here’s what I have so far.
[indent]
=IF(ISNUMBER(MATCH(B1,’Sheet2′!B1:C21,0)),INDEX(‘Sheet1′!B2:B22,MATCH(B1,’Sheet2’!A1:A22,0)),0)
[/indent]
Can someone please provide me with insight to this? I’m attaching a sample to better explain what I need to do.