Vlookup Query

[Naresh Goud]

Hello Friends,

i had small query regarding Vlookup function.


-- removed inline image ---



when i use vlookup function to get the persons rank .. i am unble to receive the results .. its displaying #NA error ..

Please do help .. , how can i retrieve the first column results with Vlookup forumla..

Naresh

 

[Robert Mika]

Hi Naresh and welcome to the board
You can not use normal VLOOKUP to retrive first column results(unless you lookup table has onle one column range) try to use INDEX/MATCH .

 

[Naresh Goud]

Thank you Robert,

Yes.. i knew about Index and match function ., thank you for clarification .

Nice day ..