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
"Cerberus" wrote in message
...
| 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.