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