Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP formula
Am using LOOKUP formula to return values and it all seems to work fine.
=LOOKUP(B19,'[andrew v2.xls]Sheet1'!$B$5:$B$28,'[andrew v2.xls]Sheet1'!$C$5:$C$28) However, when dragging and copying the formula, if the Lookup_value is not in the Lookup_vector, the formula just returns the last lookup that it could return. i.e. if the return value is 100 for a lookup of A21, if A22 does not exist in the lookup_vector, instead of returning N/A or something it will return 100... Any help appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating a field based on lookup values | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
copying LOOKUP formula | Excel Worksheet Functions | |||
How do I have a formula lookup a sheetname? | Excel Worksheet Functions |