Hi there, (i hope this makes sense)

I understand with Vlookup function you can only have a 1 column parameter?

I need to return a value by comparing 2 columns on separate worksheets and returning the 3 column.

e.g.

Sheet 1
Col A Col B Col C
157 3209838 ?
162 3209834 ?
139 3208534 ?

Sheet 2
Col A Col B Col C
157 3209838 94647
162 3209834 95648
139 3208534 96854

What I want to do is match both Col's A & B in both sheets and return Col C from Sheet 2 and place in Sheet 1 Col C.

Can this be done?

Thank you
Carmen