Mutiple Vlookups

[inquizitiv]

Hello,

My Excel workbook consists of several sheets filled with information (list of items on 6 different sheets to be exact) and I would like to create a sheet dedicated to searching for items within the workbook without having to peruse the various sheets. I thought vlookup would be a great idea for finding the information fast (with the exception of hitting ctrl F on each sheet) however; I am not having success with creating the proper vlookup formula. I read something about incorporating "indirect" into the formula but this has not been successful either. The error message I receive states that I have "entered too many arguments". Has anyone done this before? Does anyone have a better way of doing what I would like to do?

Thanks in advance

P.S. I also posted in the MS Excel 2007 forum. Wasn't sure if I needed to post here first cuz I'm new.

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.