Lookup the value

[hecgroups]

Hello,

I am seeking help on below mentioned details.

I am looking values in a list from Column E to Column B for matching. If the value match then the valued in column D to returned in Column A for match.

Example:

Name 17 with value 797100 is equals to Name 17 in B2 so the code shoureturn in A2

I hope i have provide you the clear details. Sampel file is attached for more clarification.

[NBVC]

Try:

=IFERROR(INDEX($D$2:$D$18,MATCH(B2,$E$2:$E$18,0)),"")

copied down

Note: Name17 in B2 should have a space like Name 17 in order to match...

[hecgroups]

Excelent and perfect solution. I don't know without excelforum how we will survive.

Thanks for your solution topic closed and reputation added.