| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP range lookup
HI, I have a problem with the VLOOKUP as it is working only with limited
range ( 1-90 ) out of 500 items , i wonder if any one can help me with that & why it is not working on rows more than 90 ? thanx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP range lookup
Perhaps you could post the VLOOKUP formula, a sample of the look-up values
and the table_array (in plain text) in response here. There's precious little for us to grasp (or take a good guess) as it stands now. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "xtreme_fac" wrote in message ... HI, I have a problem with the VLOOKUP as it is working only with limited range ( 1-90 ) out of 500 items , i wonder if any one can help me with that & why it is not working on rows more than 90 ? thanx |
| Reply |
| 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 | |||
Hybrid Mode
