Name error means you have a typo so you need to check that all sheet names
etc are correct and that there are no spelling errors
bj missed a parenthesis, it should be if(iserror not ifiserror although you
might want to change that to IF(ISNA instead since that is the error you are
looking to avoid, any other error might be good to know about


--
Regards,

Peo Sjoblom



"Byron720" wrote in message
...
I'm almost there, but the formula only works with data on the first sheet.
For part #'s on sheets 2 and 3 it gives me #NAME? error. I changed the PN
for
the cell, Sheets 1, 2, and 3 for the right names and fixed the ranges to
$1:$65536. Can you take a look at the formula and find the error? b'cause
I
don't see it

Byron

"bj" wrote:

try
=if(iserror(vlookup(PN,'Sheet1'!range1,2,0)),ifise rror(vlookup(PN,'Sheet2'!range2,2,0),vlookup(PN,'S heet3'!range3,2,0),vlookup(PN,'Sheet2'!range2,2,0) ),vlookup(PN,'Sheet1'!range1,2,0))

"Byron720" wrote:

How do I use the vlookup function (or else) to find data from 3
different
sheets? For example I need to extract information about a part # but
the list
is 3 sheets long. The part #'s are numeric and alphanumeric.