I have two sheets in Excel that I am trying to compare. This is a bit convoluted so I hope my explanation is clear.

Sheet 1 is named 'mapping and Sheet 2 is named SOA

I would like to compare column D in 'mapping' to column A in 'SOA'

Where the value in column D of mapping is equal to the result in column A of 'SOA' I would like to enter the corresponding text info from column B of SOA into column E (which is blank) in 'mapping'

Column A in SOA is in ascending order while column D is not, and cannot be.

A sample for the data is:

Sheet 1 (Mapping)

A B C D E
A1.3
A1.1
A1.2

Sheet 2 (SOA)

A B C D E
A1.1 YES
A1.2 MAYBE
A1.3 NO
A1.4 IDK

The result I am looking for would give me:

Sheet 1 (Mapping)

A B C D E
A1.3 NO
A1.1 YES
A1.2 MAYBE

I have tried the following formula but it is returning the value in the last row of Column B in sheet 'SOA'. Can anyone see what is wrong with it?

Sheet 'mapping' has 467 rows
Sheet 'SOA' has 136 rows

IF('mapping'!D3=SOA!A4,VLOOKUP('mapping'!D3:D466,SOA!A1:B136,2),FALSE)