vlookup in Multiple sheets

[niladri20052006]

Hi All,

Is it possible to vlookup in Multiple sheets. For example I have company name in sheet 1 and sheet 2. In sheet 3 I have also company names. I am using vlookup formula to find the match company. I am doing vlookup 2 times to find the match data.

Is it it possible to that by one vlookup?

 

[VoG]

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

 

[niladri20052006]

Hi VOG

Thanks for your reply

I have tried the code but it is not working.

Is there any other way?