Thread: Do I use a VLOOKUP or MATCH?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cerberus Cerberus is offline
external usenet poster
  
Posts: 88
Default Do I use a VLOOKUP or MATCH?
The book I'm useing is not helping me too much on this question so will ask
the experts. If I add two text cells together say A1 is "Yellow" and B1 is
"Fruit" and I get C1 to show "YellowFruit" how would I go about having
"YellowFruit" represent "Banana" in D1? Would I use a VLOOKUP or a MATCH or
IF or am I way off? Thanks for any help.
Reply With QuoteReply With Quote