Chuck.........

You are a SUPERSTAR in my book. So many times on this board you recieve
well meaning but very vague answers. You took the time to actually nwrite
out the calculation for me, and I really appreciate the effort. You have no
idea how much time this formula saves me, not to mention the data integrity
aspect of it. I wish there was some way I could repay you.

Thanks Again!

Scott D.

"CLR" wrote:

You're welcome Scott, thanks for the feedback.........

If your VLOOKUP values are numerical, this formula will work in the
Conditional Formatting feature to tell you that the lookup number was found
in the "shrinks" table.....

=VLOOKUP($D$15,SHRINKS,6,FALSE)

Format ConditionalFormatting Formula is: paste the above formula here,
and note that there are two $ in it......then format to choice

Vaya con Dios,
Chuck, CABGx3


"Scott D." wrote:

That did it! I really appreciate your help. One more thing if I may, is
there a way to Shade the result indicating that it came from the first
look-up rather than the second look-up?

Thanks Again.

"CLR" wrote:

=IF(ISNA(VLOOKUP($D15,SHRINKS,6,FALSE)),VLOOKUP($D 15,stores_ty_pl,20,FALSE),VLOOKUP($D15,SHRINKS,6,F ALSE))

....all on one line, watch out for word-wrap

Vaya con Dios,
Chuck, CABGx3



"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