Find, Match & Paste Cells

[Deepak Sharma]

Hello Everyone,

I have attached an excel sheet. Actually, V-lookup doesn't work backward. So is there any formula to search the value in a range and paste the values from the Back column.

Please see the excel file for better understanding.

Thanks and Regards,
Deepak Sharma

 

[Asheesh]

Hi,

Use the below function in F21 and drag it down

INDEX($E$5:$E$18,MATCH(E21,$F$5:$F$18,0))

See the attached

 

[Deepak Sharma]

Thank you so much Asheesh! You solved it very fast. Thanks!!!!!!!!