| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Range Lookup in VLookup ?'s
with this function I get all values to show correctly except any over the
highest lookup value IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...)) my range of part numbers to lookup are 1001-1100, so, if it is 0-1100 I get what I want with my make, model, price. However If I enter a part number ranging from 1101-9999 I get the same info as if I entered 1100. How do I make it say "0" instead? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic range for Table_array in a VLOOKUP. | Excel Worksheet Functions | |||
| Lookup in named range | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| How do I sum a range which includes the "#N/A" VLOOKUP return valu | Excel Worksheet Functions | |||
| Lookup with search range start based on position of last blank lin | Excel Worksheet Functions | |||
Threaded Mode
