You can't. VLOOKUP can search only on one sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"sgm020"
wrote in message
...

Hi,
How can use Vlookup formula for searching in Workbook in Al
Sheets.

Will You help me.

Thanks.


--
sgm020
------------------------------------------------------------------------
sgm020's Profile:
http://www.excelforum.com/member.php...o&userid=26226
View this thread:
http://www.excelforum.com/showthread...hreadid=395244