Match cell in a range and return corresponding cell

[Proteus]

Hello brains trust. Two hours trying... and I'm stuck!
I'm migrating between CRM's and need to import old data to the new CRM. Same product but different product code.
In the screenshot attached, (ignoring the Sheets for now), I want to search the range D3:D24 for the data in A3.
If found, the data in the corresponding found cell should be inserted in B3 (assuming this is where the formula goes).
In this example, A3 (29309) matches with data in D12. So the data in E12 (a010) should be shown (in B3)
If not found, return nothing.

Appreciate any help.

 

[mianmithu]

in B3 Use this Formula

=INDEX(E3:E12,MATCH(A3,D3:D12,0))

 

[KOKOSEK]

Classic

=VLOOKUP(A3,D3:E24,2,0)

does not work?

 

[Peter_SSs]

If not found, return nothing.

Then add this adjustment

=IFNA(VLOOKUP(A3,D3:E24,2,0),"")

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Proteus]

in B3 Use this Formula

=INDEX(E3:E12,MATCH(A3,D3:D12,0))

No luck with this one I'm afraid. But thanks.

 

[Proteus]

Then add this adjustment

=IFNA(VLOOKUP(A3,D3:E24,2,0),"")

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Bravo - thank you Peter_SSs this worked! You saved my brain from turning into mush! Big thanks to KOKOSEK too!
Other item noted but alas I am a heathen and fear ridicule on this esteemed forum (using Google Sheets!!). Still worked though.

 

[Peter_SSs]

Bravo - thank you @Peter_SSs this worked!

You're welcome.

using Google Sheets!!

In that case, for the future please ask your questions in the correct forum.