# Vlookup in Duplicate Result Value

1. ## Vlookup in Duplicate Result Value

Plzzzz Help,

I have the following data in sheet1.

P.Code Material Description ShortDescription
31011000 12.00-20 TUBE 12.00-20
31011500 12.00-20 INS TUBE 12.00-20
31021000 11.00-20 TUBE 11.00-20
31021500 11.00-20 INS TUBE 11.00-20
31021510 11.00-20 MT INS TUBE 11.00-20
31031000 10.00-20 INS TUBE 10.00-20
31031100 10.00-20 MT TUBE 10.00-20
31031300 10.00-20 PLUS TUBE 10.00-20
31031500 10.00-20 OE TUBE 10.00-20
31031510 10.00-20 MT INS TUBE 10.00-20
31031520 10.00-20 TR INS TUBE 10.00-20
31031600 10.00-20 FT INS TUBE 10.00-20
31031610 10.00-20 FT TUBE 10.00-20

and the data in sheet2 is:
A B C
1 Material Description ShortDescription Stk
2 11.00-20 MT INS TUBE 1
3 10.00-20 MT INS TUBE 271
4 10.00-20 TR INS TUBE 1
5 10.00-20 FT INS TUBE 9
6 10.00-20 FT TUBE 1

I need a formula in cell B2 of sheet2 to lookup the value of A2 from sheet1 in "ShortDescription" column.

Vlookup is not working here because of multiple results value. kindly help....!!!

PS : I have also attached my file.

2. ## Re: Vlookup in Duplicate Result Value

I dont understand why the regular V Look Up wont work??

I tried this is B2 and it worked.

=VLOOKUP(A2,Sheet1!\$B\$2:\$C\$415,2,0)

3. ## Re: Vlookup in Duplicate Result Value

Oopsss... Sorry!!

Try this in cell b2

=INDEX(Sheet1!\$A\$2:\$A\$415,MATCH(A2,Sheet1!\$B\$2:\$B\$415,0))

Deep

5. ## Re: Vlookup in Duplicate Result Value

yup...!! SOLVED... I got it....!!!

Thankss a lot Mr. Ramanan and msexcelathome....

6. ## Re: Vlookup in Duplicate Result Value

You are Most welcome Abhinav.

7. ## Re: Vlookup in Duplicate Result Value

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1