D
dford
Can VLOOKUP be used to search columns in multiple sheets in a workbook?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Yes, if the sheets are identical to each other.
If you have the lookup value in A2 on a summary sheet and the sheets you
want to lookup are Sheet1:Sheet8,
the table is A1:C200 and you want to return the value in the second column
(B)
=VLOOKUP(A2,INDIRECT("'"&INDEX({"Sheet1";"Sheet2";"Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"Sheet1";"Sheet2";"Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"}&"'!A1:A200"),A2)>0),0))&"'!A1:C200"),2,0)
entered with ctrl + shift & enter
if you put all sheet names in a range of cells and give it a name it is less
ugly
=VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!A1:A200"),A2)>0),0))&"'!A1:C200"),2,0)
where MySheets would hold the names
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
If you have the lookup value in A2 on a summary sheet and the sheets you
want to lookup are Sheet1:Sheet8,
the table is A1:C200 and you want to return the value in the second column
(B)
=VLOOKUP(A2,INDIRECT("'"&INDEX({"Sheet1";"Sheet2";"Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"Sheet1";"Sheet2";"Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"}&"'!A1:A200"),A2)>0),0))&"'!A1:C200"),2,0)
entered with ctrl + shift & enter
if you put all sheet names in a range of cells and give it a name it is less
ugly
=VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!A1:A200"),A2)>0),0))&"'!A1:C200"),2,0)
where MySheets would hold the names
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
L
L. Howard Kittle
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
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
L
L. Howard Kittle
Hi again Peo,
[email protected]
Thanks
[email protected]
Thanks
Peo Sjoblom said:Yes, if the sheets are identical to each other.
If you have the lookup value in A2 on a summary sheet and the sheets you
want to lookup are Sheet1:Sheet8,
the table is A1:C200 and you want to return the value in the second column
(B)
=VLOOKUP(A2,INDIRECT("'"&INDEX({"Sheet1";"Sheet2";"Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"Sheet1";"Sheet2";"Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"}&"'!A1:A200"),A2)>0),0))&"'!A1:C200"),2,0)
entered with ctrl + shift & enter
if you put all sheet names in a range of cells and give it a name it is
less ugly
=VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!A1:A200"),A2)>0),0))&"'!A1:C200"),2,0)
where MySheets would hold the names
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
D
dford
This is the formula that I would like to search on 8 different sheets. The
sheets will all be the same. The range to search is A1:E1000 on each sheet.
=IF(ISERROR(VLOOKUP(A9,'[Okeene raw
materials.xls]Sheet1'!$A$1:$E$1000,4,FALSE)),0,VLOOKUP(A9,'[Okeene raw
materials.xls]Sheet1'!$A$1:$E$1000,4,FALSE))
sheets will all be the same. The range to search is A1:E1000 on each sheet.
=IF(ISERROR(VLOOKUP(A9,'[Okeene raw
materials.xls]Sheet1'!$A$1:$E$1000,4,FALSE)),0,VLOOKUP(A9,'[Okeene raw
materials.xls]Sheet1'!$A$1:$E$1000,4,FALSE))
P
Peo Sjoblom
On its way
Peo
Peo
L. Howard Kittle said: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
L
L. Howard Kittle
Hmmmm,
Whatever this post has to do with anything...?
sorry
Howard
Whatever this post has to do with anything...?
sorry
Howard
D
dford
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))
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))
P
Peo Sjoblom
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
all are using
$B$1:$E$1000
?
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
dford said: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 said:On its way
Peo
D
dford
Yes. All sheets are identical.
Peo Sjoblom said: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 said: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 said:On its way
Peo
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
Can VLOOKUP be used to search columns in multiple sheets in a
workbook?
J
John James
Hi Peo,
Your formula appears to work without making it an array. Is the
"entered with ctrl + shift & enter" instruction necessary?
Your formula appears to work without making it an array. Is the
"entered with ctrl + shift & enter" instruction necessary?
P
Peo Sjoblom
Hi John,
the hardcoded formula works but if you use
=VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!A2:A200"),A2)>0),0))&"'!A2:C200"),2,0)
you need to array enter it. OTOH the one using a sheet list and a defined
name is smaller and has better flexibility since you don't have to edit the
formula if you add sheets
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
the hardcoded formula works but if you use
=VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!A2:A200"),A2)>0),0))&"'!A2:C200"),2,0)
you need to array enter it. OTOH the one using a sheet list and a defined
name is smaller and has better flexibility since you don't have to edit the
formula if you add sheets
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
P
Peo Sjoblom
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
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 said:Yes. All sheets are identical.
Peo Sjoblom said: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 said: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))
:
On its way
Peo
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
Can VLOOKUP be used to search columns in multiple sheets in a
workbook?
D
dford
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?
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 said: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 said:Yes. All sheets are identical.
Peo Sjoblom said: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
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))
:
On its way
Peo
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
Can VLOOKUP be used to search columns in multiple sheets in a
workbook?
P
Peo Sjoblom
=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
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address
dford said: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 said: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 said:Yes. All sheets are identical.
:
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
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))
:
On its way
Peo
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
Can VLOOKUP be used to search columns in multiple sheets in a
workbook?
J
John James
Hi again Peo,
You are, of course, correct.
I don't understand why these two formulae behave fundamentally
differently (hardcoded array versus entering array within the
spreadsheet cells), with the first returning a value and the second
returning an array.
Also, when I examine the outer "Index" array within your formula (by
selecting cells over columns and rows and entering with ctrl + shift &
enter, I can as expected see the entire array (all sheets) for the
spreadheet cells option, but surprisingly only the sheet1 array for the
hard-coded option:
Spreadsheet cells option:
=INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!A2:A200"),A2)>0),0))&"'!A2:C200")
Hardcoded option:
=INDIRECT("'"&INDEX({"Sheet1";"Sheet2";"Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"Sheet1";"Sheet2";"Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"}&"'!A2:A200"),A2)>0),0))&"'!A2:C200")
Do you know why the different behaviour applies?
You are, of course, correct.
I don't understand why these two formulae behave fundamentally
differently (hardcoded array versus entering array within the
spreadsheet cells), with the first returning a value and the second
returning an array.
Also, when I examine the outer "Index" array within your formula (by
selecting cells over columns and rows and entering with ctrl + shift &
enter, I can as expected see the entire array (all sheets) for the
spreadheet cells option, but surprisingly only the sheet1 array for the
hard-coded option:
Spreadsheet cells option:
=INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!A2:A200"),A2)>0),0))&"'!A2:C200")
Hardcoded option:
=INDIRECT("'"&INDEX({"Sheet1";"Sheet2";"Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"Sheet1";"Sheet2";"Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"}&"'!A2:A200"),A2)>0),0))&"'!A2:C200")
Do you know why the different behaviour applies?
D
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))
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 said:=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 said: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 said: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
Yes. All sheets are identical.
:
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
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))
:
On its way
Peo
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
Can VLOOKUP be used to search columns in multiple sheets in a
workbook?
J
John James
Hi dford,
It seems you're wanting to not just do a Vlookup on multiple sheets,
but do it in an entirely different workbook. This introduced other
complications. Could I suggest simplifying your problem by first
focusing on getting it working within a single workbook? Then you
might consider adjustments to cope with any errors in formulas. Then
when these problems are solved, you might consider adjustments to deal
with your desire for links across different workbooks.
Cheers,
It seems you're wanting to not just do a Vlookup on multiple sheets,
but do it in an entirely different workbook. This introduced other
complications. Could I suggest simplifying your problem by first
focusing on getting it working within a single workbook? Then you
might consider adjustments to cope with any errors in formulas. Then
when these problems are solved, you might consider adjustments to deal
with your desire for links across different workbooks.
Cheers,
B
Bryan Hessey
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))
=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 said:=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 said: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 said: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
Yes. All sheets are identical.
:
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
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))
:
On its way
Peo
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
Can VLOOKUP be used to search columns in multiple sheets in a
workbook?