| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
LOOKUP command
Hey.
I am trying to use the following lookup but it keeps returning an error. Can you help? Thanks :) =LOOKUP(a17,{a219,a220,a221,a222,a223,a224,a225,a2 26,a227,a228},{c219,c220,c221,c222,c223,c224,c225, c226,c227,c228}) |
|
#2
|
|||
|
|||
|
"excelnewbie" wrote...
I am trying to use the following lookup but it keeps returning an error. Can you help? =LOOKUP(a17,{a219,a220,a221,a222,a223,a224,a225,a 226,a227,a228}, {c219,c220,c221,c222,c223,c224,c225,c226,c227,c22 8}) =LOOKUP(A17,A219:C228) |
|
#3
|
|||
|
|||
|
Hi!
Try this: =VLOOKUP(A17,A219:C228,3,0) Biff "excelnewbie" wrote in message ... Hey. I am trying to use the following lookup but it keeps returning an error. Can you help? Thanks :) =LOOKUP(a17,{a219,a220,a221,a222,a223,a224,a225,a2 26,a227,a228},{c219,c220,c221,c222,c223,c224,c225, c226,c227,c228}) |
|
#4
|
|||
|
|||
|
"Biff" wrote...
Try this: =VLOOKUP(A17,A219:C228,3,0) .... Why include the 4th argument? |
|
#5
|
|||
|
|||
|
I always default to FALSE out of habit.
Biff "Harlan Grove" wrote in message ... "Biff" wrote... Try this: =VLOOKUP(A17,A219:C228,3,0) ... Why include the 4th argument? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup more than one cell | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
