How to VLOOKUP multiple sheets and each sheet have 65536 rows?

Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 15

How to VLOOKUP multiple sheets and each sheet have 65536 rows?

Dear Expert,

I have a total of 190,000 rows of data split onto 3 spreadsheets.
How to VLOOKUP all 3 spreadsheet?

Example:-
Column A is part number and B is Description.

Part# Description
12345 A
12346 B
12347 C
12348 D
12349 E
12350 F
12351 G
12352 H
12353 I
12354 J
12355 K
12356 L
12357 M

Your support is greatly appreciated.

BR//nginhong

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
more than 65536 rows	Christopher Naveen[_2_]	Excel Discussion (Misc queries)	13	September 21st 07 04:42 PM
Auto link rows of information from multiple sheets to single sheet	Steve R	Excel Discussion (Misc queries)	3	November 8th 06 06:13 AM
Can I put more than 65536 rows in one Excel sheet?	Office user	Excel Worksheet Functions	2	September 26th 05 11:08 PM
Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95?	[email protected]	Excel Discussion (Misc queries)	12	July 22nd 05 12:50 PM
how can i increase number of rows beyone 65536 in excel sheet	increasing number of rows in excel sheet	Excel Discussion (Misc queries)	2	April 28th 05 07:03 AM

All times are GMT +1. The time now is 06:53 AM.

Menu

About Us