Hi!

This all depends on how your lookup table is setup.

Need more detail.

Biff

-----Original Message-----
how would i do a lookup to return a value if two
conditions are met.
instead of =vlookup(a1,d1:h80,2,0) i would like a value
to return if a1 and
b1 are matched?
thank you

c
.