Help with Lookup Calculation
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
|