Vlookup Help Please.. :)

[jodiefullerton]

Hi there,

I am struggling to get this to work and its bugging me! i hope you lovely people can help me.

Basically if the content within column A and B of sheet one, matches the content of column A and B on sheet 2, then insert date from column D on sheet 2 into column J on sheet 1

I hope this makes sense.

Thanks so much.

Jodie

 

[VBE313]

How about

=IF(CONCAT(A1:B1)=CONCAT(Sheet2!A1:B1),Sheet2!D1,"")

 

[jodiefullerton]

Hi thank you for this. Sheet 2 is part of the workbook, when I popped this formula in it popped up with a box to let me open a spreadsheet? Unless I am doing something...

 

[Joe4]

Assuming there is no more than one match for each combination, here is one way (assuming starting on row 1):

=SUMPRODUCT(--(Sheet2!A:A=Sheet1!A1),--(Sheet2!B:B=Sheet1!B1),(Sheet2!D:D))

This will return 0s for the values that don't match.
You can use Conditional Formatting to hide those values, if you like.

 

[VBE313]

Hi thank you for this. Sheet 2 is part of the workbook, when I popped this formula in it popped up with a box to let me open a spreadsheet? Unless I am doing something...

Hmm I am not sure. I just entered that formula into Sheet1!J1

 

[Peter_SSs]

Try this. Check the sheet name & row range.

=IFERROR(INDEX(Sheet2!D:D,AGGREGATE(15,6,ROW(Sheet2!A$1:A$10)/((Sheet2!A$1:A$100=A2)*(Sheet2!B$1:B$100=B2)),1)),"")

 

[jodiefullerton]

Superstar that worked out amazingly!