I searched, but did not find a specific answer for what I am trying to do...
I need to match the values in Column A and Column D on Sheet1 with the same values in Column A and Column H in Sheet2, then place the value of column H found in that row of Sheet1 into Sheet2
I tried this but no joy:
=INDEX(Sheet1!$A$2:$V$59,MATCH(Sheet2!$A2&"|"&$H2,Sheet1!$A$1:$H$7,0))
I am trying to place the value found in Sheet1 column H into Sheet2 column BB
I need to match the values in Column A and Column D on Sheet1 with the same values in Column A and Column H in Sheet2, then place the value of column H found in that row of Sheet1 into Sheet2
I tried this but no joy:
=INDEX(Sheet1!$A$2:$V$59,MATCH(Sheet2!$A2&"|"&$H2,Sheet1!$A$1:$H$7,0))
I am trying to place the value found in Sheet1 column H into Sheet2 column BB