Lookup Function
 

I have a table set up where ARC and CRA are two separate entities and have
two separate values associated with them (ie. ARC=4568, CRA=3978). When I do
a lookup using these strings, it give the value ARC=4568, and CRA=4568. I
assume because they contain the same letters, just in a different order. I
think Excel sees ARC and CRA as being the same thing. Is there a way around
this??

THanks

Chris

Christopher,

It looks like you have the lookup function structured wrong. Excel should
be able to find the correct value. You might want to look at the on-line
help for the correct syntax.

----
Regards,
John Mansfield
http://www.pdbook.com

"Christopher Anderson" wrote:

I have a table set up where ARC and CRA are two separate entities and have
two separate values associated with them (ie. ARC=4568, CRA=3978). When I do
a lookup using these strings, it give the value ARC=4568, and CRA=4568. I
assume because they contain the same letters, just in a different order. I
think Excel sees ARC and CRA as being the same thing. Is there a way around
this??

THanks

Chris

What formula did you use? If the formula is referring to a table, is the
table sorted in ascending order on its first column? Also, did you see
the replies to your initial post?

Christopher Anderson wrote:
I have a table set up where ARC and CRA are two separate entities and have
two separate values associated with them (ie. ARC=4568, CRA=3978). When I do
a lookup using these strings, it give the value ARC=4568, and CRA=4568. I
assume because they contain the same letters, just in a different order. I
think Excel sees ARC and CRA as being the same thing. Is there a way around
this??

THanks

Chris

Hi Chris,

You probably left out the last argument, 0, as in Max' example

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Christopher Anderson" wrote
in message ...
I have a table set up where ARC and CRA are two separate entities and have
two separate values associated with them (ie. ARC=4568, CRA=3978). When I
do
a lookup using these strings, it give the value ARC=4568, and CRA=4568. I
assume because they contain the same letters, just in a different order.
I
think Excel sees ARC and CRA as being the same thing. Is there a way
around
this??

THanks

Chris