Matching Data

Question

I have 4 columns:A a set of numbersB a date that relates to that numberD a set of numbersE a blank column&nbsp;&nbsp;what would be the formula that would check if:A matches D then put in E the date from B&nbsp;

preagan · Answer

Hello&nbsp;MaxSmith4,&nbsp;In general, for E1 that would be:=IF(A1=D1, B1, "no match")&nbsp;

maxsmith4 · Answer

Hello PReagan&nbsp;Thank you but this isn't what I am looking for,for example A3 may match to D23 etc. they arent always in the same row. &nbsp;

preagan · Answer

MaxSmith4&nbsp;&nbsp;I think I understand. Try this in E2:=VLOOKUP(D2,$A$2:$B$483,2,FALSE)&nbsp;copy down and format as short date.

maxsmith4 · Answer

PReaganAmazing thank you&nbsp;

kashibaba · Answer

This will work for you, enter this formula in E=INDEX($B:$D,MATCH(A3,$A:$A,FALSE),1)

Forum Discussion

Matching Data

6 Replies