Hi, i want the color of the fruit to show according to the answer excel gives.
Please see attachment.
Hi, i want the color of the fruit to show according to the answer excel gives.
Please see attachment.
Put this formula in cell E16:
=IF(E15="","",IFERROR(VLOOKUP(E15,A2:B8,2,0),""))
Hope this helps.
Pete
Excellent, Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks