Hi I'm currently running office 2000 and trying to get vlookup to work
properly.

I have 10 tables which must be referenced from one formula.
The formula must pick which table to use (currently have that working)
the formula must pick which row and column to use (currently have that
working)

I know that that I just said the formula works and it does. However it only
works for numbers = 76 and I need it to work for any numbers entered

Here is the exact formula being used:

=IF(ISERROR(VLOOKUP(C3,INDIRECT("Sheet"&B3&"!"&"A1 :U151"),Data!E3,TRUE))=TRUE," ",VLOOKUP(C3,INDIRECT("Sheet"&B3&"!"&"A1:U151"),Da ta!E3,FALSE))

As I say this formula works just fine for me for numbers 76-150 (150 is the
highest number on the table) and returns the correct result. Numbers 1-75
however do not return anything and there is data in the table that should be
returned. (Note there are 151 rows in the tables on the other sheets)

The tables contain both numeric and alphanumeric data and where the formula
returns data both are returned fine.

One thing the formula does not do that I would like it to (though its not
neccessary) is in the event of no exact match returning the next largest
number that is smaller than the search value.

Hopefully this is a fixable problem.
If you need additonal info please just let me know.

Jaime