VLOOKUP in multiple sheets

[abrajput]

Also is there a way to do a VLOOKUP for a perticular value from multiple sheets in a workbook. Say I have 9 sheets with different name and I want to do Vlookup from columnB in every sheet. Right now I am doing VLOOKUP individually for each sheet. Can I do it in a single command?

 

[VoG]

Try this http://www.ozgrid.com/VBA/VlookupAllSheets.htm

 

[Yahya]

you can also use the idea from aladin here
http://www.mrexcel.com/forum/showpost.php?p=1988378&postcount=3

 

[abrajput]

This formula did not work . Can anyone suggest a formula to resolve this?

 

[Yahya]

This formula did not work . Can anyone suggest a formula to resolve this?

which formula ???