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...
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
