Using VLOOKUP for more than 1 column

I guess you will need VBA.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

No need for VBA, I think. Try this. if this ISN'T what you need, please upload a sample file.

Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon

All you needed to do was make a tiny alteration to the formula that I gave you in the earlier post:

=IFERROR(INDEX(Data!C$2:C$7,MATCH(1,INDEX((Data!$A$2:$A$77=Worksheet!$C2)*(Data!$B$2:$B$7=Worksheet!$D2),0),0)),"Error")

or
A2

Please Login or Register  to view this content.

=IFERROR(LOOKUP(2,1/((Data!$A$2:$A$7=$C2)*(Data!$B$2:$B$7=$D2)),Data!C$2:C$7),"error")
Try this and copy across

you're welcome ... and thanks for the rep.