Vlookup related problem

[katik aggarwal]

Lets have an example of the problem I am facing - 

Sheet 1 

Name         Amount

Rahul          23324

Ram            45432

Shyam        23232

Kartik          56342

Nikhil          21233

Ankit           45432

Lucky          56342                  

Harsh          54354

Vinay          29789

Rajesh        32322

Sheet 2

Amount       PAN                

23324         weewewwer

45432         wefewfgw

23232         svfrewfewre

56342         fwrffdwww

21233         wefewfggww

45432         werfewfefc

56342         iuliejfhefjw

54354         fewklewjflehf

29789         wefjefhdcjww

32322         wefouwefiou

Now if we apply Vlookup in sheet 2 

For the 2nd amount of 45432 and 56342, the ans. shall be ram & kartik. 

Is there some way to solve the problem.

Also please tell me the function of "Range lookup" in the vlookup function.

[Saran Kumar]

Dear Karthik,

You can use the below function to lookup the right side items using vlookup. However, you have a choice of using Index & match.

=VLOOKUP(A2,CHOOSE({1,2},Sheet1!$B$2:$B$11,Sheet1!$A$2:$A$11),2,0)

Please find the attached excel format and download with the same example

Thanks

Regards,

Saran

[katik aggarwal]

u r not getting my problem.. 
what m actully asking is that .. bcz of repetition in amounts.. I am not getting right ans ..

I there any sol. for that.

BTW this ans was also helpful for increasing some of my knowledge. :) TY.

[Manoj Kumar]

Hi Kartik,

Could you please share me the problem in excel file.

I will definitely help you.