It's not clear what you mean, do you want to lookup A1 and B1 in one column
of the lookup table? If so use

=VLOOKUP(A1&B1,D1:H80,2,0)

if not post back

Regards,

Peo Sjoblom

"CMAC" wrote:

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