Lookup Function

[Guest]

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

 

[Guest]

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.

 

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

 

[Niek Otten]

Hi Chris,

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel