Lookup Function

[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

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

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

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

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

[Niek Otten]

Hi Chris,

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Christopher Anderson" <ChristopherAnderson@discussions.microsoft.com> wrote
in message news:3B5D1E7C-2C3E-4B03-A18C-5F71850BF409@microsoft.com...
>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