Do I use a VLOOKUP or MATCH?

  • Thread starter Thread starter Cerberus
  • Start date Start date
C

Cerberus

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.
 
If this were a multiple choice test question I'd look for the "Not enough
information" answer. However, if you have a table somewhere that lists
items like "YellowFruit" in its first column and things like "Bananas" in
the second column I'd say VLookup is the way to go.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup question - bring in all values? 6
how do i use the text in a cell as a named range in a vlookup form 2
=IF(ISNA(VLOOKUP(A1,Data!$B$1:$C$200,MATCH(A1,Data!$A$1:$C$1,IF($V 3
Need help in Combining If formula with Vlookup 2
vlookup cell reference 2
vlookup with dropdown list 2
opposite of vlookup function? 8
creating nested formulas from drop down box 5

Back
Top