Thanks ,Ms-Exl-Learner
Your formula is well, but i need display only the description, no the
commentaire.

Is possible ?

"Ms-Exl-Learner" wrote:

May be this€¦

If you want to combine Vlookup for all the three sheets in one formula then
try the below:-

=IF(A1="","",IF(ISNA(VLOOKUP(A1,Product01!A:B,2,FA LSE)),"["&UPPER(A1)&" Not
Available In Product01
Sheet]",IF(VLOOKUP(A1,Product01!A:B,2,FALSE)=0,"[Description is blank for
"&UPPER(A1)&" In Product01 Sheet]","[Product01 :
"&VLOOKUP(A1,Product01!A:B,2,FALSE))&"]")&CHAR(10)&IF(ISNA(VLOOKUP(A1,Product02!A:B,2,FAL SE)),"["&UPPER(A1)&"
Not Available In Product02
Sheet]",IF(VLOOKUP(A1,Product02!A:B,2,FALSE)=0,"[Description is blank for
"&UPPER(A1)&" In Product02 Sheet]","[Product02 :
"&VLOOKUP(A1,Product02!A:B,2,FALSE))&"]")&CHAR(10)&IF(ISNA(VLOOKUP(A1,Product03!A:B,2,FAL SE)),"["&UPPER(A1)&"
Not Available In Product03
Sheet]",IF(VLOOKUP(A1,Product03!A:B,2,FALSE)=0,"[Description is blank for
"&UPPER(A1)&" In Product03 Sheet]","[Product03 :
"&VLOOKUP(A1,Product03!A:B,2,FALSE)&"]")))

If you want the individual Vlookup formula then try the below:
Product 01:-
=VLOOKUP(A1,Product01!A:B,2,FALSE)

Product 02:-
=VLOOKUP(A1,Product02!A:B,2,FALSE)

Product 03:-
=VLOOKUP(A1,Product03!A:B,2,FALSE)
--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"tran1728" wrote:

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.