Lookup Function

  • Thread starter Christopher Anderson
  • Start date
C

Christopher Anderson

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
 
J

John Mansfield

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

Aladin Akyurek

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?
 
N

Niek Otten

Hi Chris,

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top