vlookup in Multiple sheets

[niladri20005]

Hi All,

I have a problem. I have a workbook consisting of four sheets as $10-50M, $50-100M, $100-250M and $250-500M. All total I have 369 data in above mentioned four sheets.
Here I have Company Name. websites, employee range, Revenue Range and state columns.

In another sheet named by "Total" I have only the company names.I want all other info from available (websites, employee range, Revenue Range and state) in all "Total" sheet.

I do not want use vlookup multiple time with columns functions.

I want to use vlookup for a single time and want to pick up all other info from other four sheets.

Is it possible to do that?

[Haseeb Avarakkan]

Hello, Niladri,

See the attached. Hope this helps