Forum Discussion
Where text in one cell matches text another cell populate the value in the adjacent cell
I am trying to create a formula that when I paste text in to blank cells D2:D11 the cells adjacent (E2:E11) contain a formula that checks cells J2:J7 and if the text in D2 matches any data in cells J...
In E2:
If you have Office 2021 or Microsoft 365:
=XLOOKUP(D2,$J$2:$J$7,$I$2:$I$7,"")
In any version:
=IFERROR(INDEX($I$2:$I$7,MATCH(D2,$J$2:$J$7,0)),"")
Fill down to E11.
HansVogelaar many thanks that has worked a treat. Much appreciated.
It is interesting that the formula works perfectley in the same worksheet but if the list of look up data is contained in an adjoining spreadsheet (same workbook) it doesnt.
Many thanks and Merry Christmas