Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP problems
I'm using the LOOKUP vector function to ascribe text data to numeric values
(e.g. returning "2a" for the number "15") successfully. I want to be able to operate the LOOKUP table in reverse (i.e. return "15" for a value entered of "2a") but it is not working accurately. I either get an error message or an incorrect value from elsewhere in the LOOKUP table. The text values take the form: 1c, 1b, 1a, 2c, 2b, 2a etc. Is this the problem? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP problems
For LOOKUP the values must be in ascending order:
1a,1b,1c..... etc "Martin Ledgard" wrote: I'm using the LOOKUP vector function to ascribe text data to numeric values (e.g. returning "2a" for the number "15") successfully. I want to be able to operate the LOOKUP table in reverse (i.e. return "15" for a value entered of "2a") but it is not working accurately. I either get an error message or an incorrect value from elsewhere in the LOOKUP table. The text values take the form: 1c, 1b, 1a, 2c, 2b, 2a etc. Is this the problem? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP problems
Yep - solved it now. Cheers.
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP problems
You can also use VLOOKUP and use any order as long as you put FALSE or 0
as the 4th argument in the formula =VLOOKUP(A2,{"1c",15;"1b",15;"1a",15;"2c",15;"2b", 15;"2a",15},2,0) as an example -- Regards, Peo Sjoblom "Martin Ledgard" wrote in message ... Yep - solved it now. Cheers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with LOOKUP | Excel Worksheet Functions | |||
v-lookup problems | Excel Worksheet Functions | |||
Lookup problems | Excel Worksheet Functions | |||
lookup problems | New Users to Excel | |||
lookup problems | Excel Worksheet Functions |