Do you mean

=VLOOKUP(A1&B1,M1:P20,3,False)

perhaps?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mike" wrote in message
...
I am trying to add vlookup figures together and some return #N/A, which
leads
to no values being returned at all. Is there anyway around this