Forum Discussion

Copper Contributor

Mar 06, 2020

Matching Data

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 da...

Formula.xlsx27 KB

excel

Formulas and Functions

PReagan

Bronze Contributor

Mar 06, 2020

Hello MaxSmith4,

In general, for E1 that would be:

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

MaxSmith4

Copper Contributor

Mar 06, 2020

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.

Kashibaba
Brass Contributor
Mar 06, 2020
This will work for you, enter this formula in E
=INDEX($B:$D,MATCH(A3,$A:$A,FALSE),1)
PReagan
Bronze Contributor
Mar 06, 2020
MaxSmith4

I think I understand. Try this in E2:
=VLOOKUP(D2,$A$2:$B$483,2,FALSE)
copy down and format as short date.
- MaxSmith4
  Copper Contributor
  Mar 06, 2020
  PReaganAmazing thank you
  - PReagan
    Bronze Contributor
    Mar 06, 2020
    MaxSmith4
    
    My pleasure!