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.