Nested Vlookup Function

Hi Everybody,

Could someone please help me out with a nested vlookup function.

I have attached the sample workbook.This workbook has six worksheets.

First sheet has product name and Price column.(Main Sheet)

I need a nested vlookup function which should search the product name in all the other five sheets and return the value of price in price column.

If the product is not found in all the other five sheets then the price cell should show blank.

This may help you

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

Regards