I'm almost there but I can't figure out the entire formula.

"John C" wrote:

From a previous post by Teethless Mama
Download and install the free add-in Morefunc.xll from:
http://www.download.com/Morefunc/300...-10423159.html
The MOREFUNC site has been hacked. http://xcell05.free.fr/
...then use this formula
=VLOOKUP("your_criteria",THREED(Sheet1:Sheet4!A1:D 100),2,0)
etc...
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Byron720" wrote:

I have a report with this information:

Part Part Description New Buy RV Net Repair

The report is 4 worksheet long. I need a formula that looks thru the 4
worksheets and finds the information for any part # I type.