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.