| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zeros problem in LOOKUP?
I have a working LOOKUP function in a spreadsheet referencing another page,
but when I copy it, or even retype it in the other rows, it returns the #N/A error. The only difference that I can see is that for some of the other rows, there are 0 amounts- could that be messing it up? This is what the working one is: =VLOOKUP($AK7,Sheet5!D3:CE34,80,FALSE), and this the non working in the next row: =VLOOKUP($AK8,Sheet5!D3:CE34,80,FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup problem: Row height doesnt adjust | Excel Discussion (Misc queries) | |||
| LOOKUP function problem? | Excel Worksheet Functions | |||
| Vertical Lookup problem | Excel Worksheet Functions | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
