Matching Data

[MaxSmith4]

I have 4 columns:

A a set of numbers

B a date that relates to that number

D a set of numbers

E a blank column

 what would be the formula that would check if:

A matches D then put in E the date from B 

[#2]

Hello @MaxSmith4,

In general, for E1 that would be:

=IF(A1=D1, B1, "no match")

[#3]

Hello @PReagan

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.  

[#4]

@MaxSmith4 

I think I understand. Try this in E2:

=VLOOKUP(D2,$A$2:$B$483,2,FALSE)

 copy down and format as short date.

[#5]

@PReaganAmazing thank you 

[#6]

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

[#7]

@MaxSmith4 

My pleasure!