Formula Help VLOOKUP

[zone709]

I am close but cant get it to go. Says this value doesn't match the data validation restrictions defined for the cell. Anyone can help thanks.
Trying to Match whats in D column to the E column of mapping table and return what's in E. Why i have 4 a b c d

=IFERROR(VLOOKUP(@$D$8:$D$500, 'Mapping Table'!$A$2:$E$2500,4,0),"")

 

[Joe4]

In a VLOOLKUP formula, the column you are matching on need to be LEFT-MOST column of your lookup range.
Because the column you want to return (column D) is to the of your matching column (column E), you cannot use VLOOKUP.
However, since you are using Excel 365, you should be able to use LOOKUP.

I think your formula should look something like this:

=IFERROR(LOOKUP(@$D$8:$D$500,'Mapping Table'!$E$2:$E$2500',Mapping Table'!$D$2:$D$2500),"")

See here for a deeper explanation of the LOOKUP function: LOOKUP function - Microsoft Support

 

[zone709]

Thank you for the reply. i will try it tomorrow and let you know.

 

[Alex Blakenburg]

Are you switching between versions of Excel, the "@" symbol concerns me ?
If you are using MS365 just use XLookup.
Syntax is: =XLOOKUP(lookup_value, lookup_array, return_array, if_not_found)

=XLOOKUP($D$8:$D$500, 'Mapping Table'!$E$2:$E$2500, 'Mapping Table'!$D$2:$D$2500, "")

 

[zone709]

Hi Alex it comes up the Value doesn't match on your formula?

 

[zone709]

In a VLOOLKUP formula, the column you are matching on need to be LEFT-MOST column of your lookup range.
Because the column you want to return (column D) is to the of your matching column (column E), you cannot use VLOOKUP.
However, since you are using Excel 365, you should be able to use LOOKUP.

I think your formula should look something like this:

=IFERROR(LOOKUP(@$D$8:$D$500,'Mapping Table'!$E$2:$E$2500',Mapping Table'!$D$2:$D$2500),"")

See here for a deeper explanation of the LOOKUP function: LOOKUP function - Microsoft Support

Joe i also tried yours =IFERROR(LOOKUP(@$D$8:$D$500,'Mapping Table'!$E$2:$E$2500',Mapping Table'!$D$2:$D$2500),"") but comes up there is a problem with the formula

Then directs me to here. $E$2500' I fixed this $E$2500 and also added this 'Mapping Table' but still no go.