It works as


=IF(ISERROR(VLOOKUP(A10,[Spanish.xls]Meats!$A$1:$E$1000,5,FALSE)),0,VLOOKUP(A10,[Spanish.xls]Meats!$A$1:$E$1000,5,FALSE))

which you can adapt to your longer names.
ie, as

=IF(ISERROR(VLOOKUP(A10,'[Ingrediants Spanish
Pork.xls]Meats'!$A$1:$E$1000,5,FALSE)),0,VLOOKUP(A10,'[Ingrediants
Spanish Pork.xls]Meats'!$A$1:$E$1000,5,FALSE))

--

QUOTE=dford]I still can't seem to make this work. Below is the formula
that works with
one sheet named "Meats". It is in a workbook called "Ingredients
Spanish
Fork". I have a range named in this workbook called "Catagories" of
which
Meats is one cell in the Catagory range. I need the formula to look at
the
"Catagories" range so it will include all 11 sheets in the range.

=IF(ISERROR(VLOOKUP(A10,'[Ingredients Spanish
Fork.xls]Meats'!$A$1:$E$1000,5,FALSE)),0,VLOOKUP(A10,'[Ingredients
Spanish
Fork.xls]Meats'!$A$1:$E$1000,5,FALSE))

"Peo Sjoblom" wrote:


=VLOOKUP(A2,INDIRECT("'[3DVLOOKUP.xls]"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'[3DVLOOKUP.xls]"&MySheets&"'!A2:A200"),A2)0),0))&"'!A2:C200"),2, 0)


--


Regards,

Peo Sjoblom


Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address


"dford" wrote in message
...
I still haven't quite got it yet. I have named a range with the
worksheet
names included called "Catagories" in a workbook called
"Ingredients
Spanish
Fork". The Vlookup formula is in a different workbook. How do I
refer to
the
the different workbook and range name in the formula?

"Peo Sjoblom" wrote:

You can download an example here

http://nwexcelsolutions.com/Download/3DVLOOKUP.xls

adapt it to fit your needs

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"dford" wrote in message
...
Yes. All sheets are identical.

"Peo Sjoblom" wrote:

Are your worksheets identical in layout like table construction
where
they
all are using

$B$1:$E$1000

?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"dford" wrote in message
...
I use the formula below to search 1 worksheet. What is the
best way
to
be
able to search multiple worksheets?

=IF(ISERROR(VLOOKUP(A9,'[Ingredients Spanish

Fork.xls]Sheet1'!$B$1:$E$1000,4,FALSE)),0,VLOOKUP(A9,'[Ingredients
Spanish
Fork.xls]Sheet1'!$B$1:$E$1000,4,FALSE))


"Peo Sjoblom" wrote:

On its way

Peo



"L. Howard Kittle" wrote in message
...
Hi Peo,

WOW....!!

Could you send me an example workbook that demonstrates
that
lookup
formula, please?

Maybe with some description of some of the details..?

Many thanks, as always, for your contributions.

Regards,
Howard

"dford" wrote in
message

...
Can VLOOKUP be used to search columns in multiple sheets
in a
workbook?













--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=531235