Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing a Function | Excel Discussion (Misc queries) | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |