View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nginhong nginhong is offline
external usenet poster
 
Posts: 15
Default 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