Hi guys,
I'm a relative newbie to formulas, so please forgive my ignorance.
The scenario is:
- Take a number in the cell at Sheet2!A2 and check the range in Sheet1!A2:A1250 for a match.
- If Sheet2!A2 matches a cell in Sheet1!A2:A1250, take the value from the matching row cell in Sheet1!C2:C1250 and place the text from that match C column cell and drop it into Sheet2!C2
I hope this makes sense?
Any help on the appropriate formula to use would be very much appreciated!
Thanks,
Ally
Bookmarks