Posted to microsoft.public.excel.misc

tran1728

external usenet poster

Posts: 28

Vlookup for 3 sheets

Dear All, pls help me.
I want to make a Vlookup, the data of Product est very big, Column A is
Item, Column B is Description, there have 3 Sheets for product ( Product01,
Product02 and Product03 ) .

I know just to do for Product01.
=VLOOKUP(A1,Product01!A:B,2,FALSE)

Pls help me the formula also for Product01!A:B, Product02!A:B and
Product03!A:B

Thanks so much.

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
vlookup 3 sheets	Ben	Excel Worksheet Functions	1	March 8th 10 03:06 AM
Vlookup using different sheets	Cpt. Costanzo	Excel Discussion (Misc queries)	3	June 17th 09 04:41 PM
Vlookup across several sheets	Elton Law[_2_]	Excel Worksheet Functions	3	April 28th 09 05:58 PM
VLookup from many sheets	Byron720	Excel Discussion (Misc queries)	0	January 23rd 08 01:47 AM
VLOOKUP Between Sheets	MB	Excel Worksheet Functions	3	October 20th 06 05:03 PM

All times are GMT +1. The time now is 07:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us