Update the name with the code based on two criteria

[gcolegcole42]

Hello,

I am looking for a vlookup that looks at two criteria's and populates the code in cell C in the tab 'Input' based on the information shown in the site tab

[nick.williams]

I'm a bit confused what you actually want to populate and based on what?

Have guessed you are trying to populate J2 in "Input" taken from column C of "Site" when columns A and B of "Site" match H2 and I2 of "Input. In which case try:

=INDEX(Site!C:C,MATCH(H2&"^^"&I2,Site!A:A&"^^"&Site!B:B,0))

[gcolegcole42]

I want a formula that looks at the 'Site' tab columns A & B and inputs the Code from cell C from the 'Site' tab into the tab 'Input' cell C based on site and and unique code

[nick.williams]

Ok, then try this in C2, and copy down:

=INDEX(Site!C:C,MATCH(A2&"^^"&B2,Site!A:A&"^^"&Site!B:B,0))

Basically what I had before but move the references from H and I to A and B.

[gcolegcole42]

No does not work

[nick.williams]

Could you upload your workbook of it not working, or explain more clearly what is not working about it?

I used the example sheet you provided and it works for me.