Vlookup On Multiple Tabs

mccloudm · May 21st 2007

I have imported a table from my access database. sadly, it has over 65536 rows. I am going to have to break table down into mulitiple sheets on excel.

Using a VLOOKUP formula normaly like this.

Code

=VLOOKUP(E5,MHIFUPK,5,0)

where E5 is my target,MHIFUPK is the sheet with the table array, and 5 is the price of E5. Now I will have multipe sheets, and I need to be able to refreance all of them in order to find E5. Anyway to do this besides upgrading to 2007, (wish I could get the company to upgrade)

Thank you.
Michael McCloud

Anonymous · May 21st 2007

Re: Vlookup On Multiple Tabs

mccloudm, Welcome to the forum. However, please don't put code tags round formulas, only round VBA code.

filo65 · May 21st 2007

Re: Vlookup On Multiple Tabs

mccloudm,

why instead of importing the table, don't you run a query in Excel for the value in E5?
let do the work to the database. It's faster, takes less memory and you have no row limitations

filippo

Vlookup On Multiple Tabs

Participate now!

Share