Hi,
I have the below it looks at each cell in column D and returns a result from a list (column A), if there is a word found that matches one in column A.
I would like to return the value in column B instead of A but look still look up the values in column A.
How would I amend the below to do that:
Please Login or Register to view this content.
Bookmarks