Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |