=If(iserror(vlookup1),vlookup2,vlookup1)

Assuming it will occur in one or other.

HTH

"Scott D." wrote:

I need to combine the following lookup statements, if it finds the value in
the first look-up I want to use that number. If the number does not exzist
in the first look-up, then I want it to use the swecond look-up (in which the
number will always be found). Here are my 2 look-up statements in the proper
order.

=vlookup($D15,shrinks,6,false)

=vlookup($D15,stores_ty_pl,20,false)

I appreciate your help