Question Regarding Vlookup

[narendra1302]

Dear All,

I am using Vlookup to get some data form one sheet to another.

I am fetching data for particular Product number. However it the Product number come more than one time - that is 2, 3, 4 times then how to get it ?

Thanks

Narendra Jadhav

 

[WinteE]

Try the UDF =ARLOOKUP() that you can find on www.excelguide.eu

 

[narendra1302]

Dear WinteE,

Thanks for showing intrest.

I have posted my question on This site.

Thanks
Narendra

 

[grizz]

lets assume your data is in sheet1 A2:A27 = product #
B2:B27 = data to lookup
in sheet 2 A1 is your lookup then in B1 or were ever you would like to start put in this formula and it is an array so must be entered withCtrl Shift + enter --- not just enter

=IF(COLUMNS($A$1:A1)<=COUNTIF(sheet1!$A$2:$A$27,$A1),INDEX(sheet1!$B$2:$B$27,SMALL(IF(sheet1!$A$2:$A$27=$a1,ROW(sheet1!$A$2:$A$27)-ROW(sheet1!$A$2)+1),COLUMNS($a$1:a1))),"")

and copy across

 

[narendra1302]

Dear Grizz,

Thanks for showing intrest.

However how can we find the entry if we have multiple sheets - from where we have to find the entry. Sorry I had not mentioned in my first post.

Thanks
Narendra

 

[Marcelo Branco]

Hi,

Maybe this can help

http://office.microsoft.com/en-us/e...ultiple-corresponding-values-HA001226038.aspx

M.

-EDIT-
I hadnt seen your last post
This article doesnt deal with multiple sheets

 

[narendra1302]

Dear Marcelo Branco,

Thanks for the article.

However - I wanted it for Multipl sheets.

Thanks
Narendra

 

[narendra1302]

Hi,

Any update ?