i need to look up in reverse

[sarsukanth]

Hi All,

actually i need to look up the value in reverse order, means my source data will be there in C column and my resulted column will be A.
Is is possible, if yes please reply back with solution.
Advance thank you.

Raghukanth

 

[VoG]

Try using INDEX and MATCH http://www.contextures.com/xlFunctions03.html