ExcelBanter - VLOOKUP range lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP range lookup (https://www.excelbanter.com/excel-worksheet-functions/60943-vlookup-range-lookup.html)

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

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