Multiple Vlookup

[Sathish KV]

Hi All,

Check out the attached file

You can vlook up for multiple values and bring them adjacent to the vlookup value

 

[Abhijeet]

can u upload .xls file

 

[Sathish KV]

Hi,

Have uploaded 2003 version

 

[Abhijeet]

i have also got same formula but if i add more column in C Grade in column D Qyt then how will get that data

 

[Sathish KV]

Hi,

What is the output required
Could you upload a file

 

[Abhijeet]

Hi
I have this macro can u modified to this.I want more data from database

 

[Sathish KV]

Hi,

Upload the macro file. let me try

 

[Abhijeet]

This is macro file

 

[Abhijeet]

This is my original file i have data in column A,B,C i want from other data is in column H i want Doc ref & page from main data

 

[vrunda]

See answer in previous thread http://chandoo.org/forum/threads/i-need-formula-for-search-the-data.17665/#post-106769

 

[Sathish KV]

Hi,

Refer attached file

Just coping the fomula to adjacent cell will not work since you have two different criterias.

You need to change the column number each time

 

[Abhijeet]

U check the macro file please give me macro in this

 

[Haseeb A]

Hello Abhijeet,

Try something like this Array Formula in I4, then copy down & across. To remove error values use a conditional formatting with background font color.

=IF(COUNTIF($H$3:$H3,$H3)=1,INDEX($A:$B,SMALL(IF($C$3:$C$8=$H3,ROW($C$3:$C$8)),COUNTIF($I$2:I$2,I$2)),MATCH(I$2,$A$2:$B$2,0)),"")

 

[Haseeb A]

...vlook up for multiple values and bring them adjacent to the vlookup value

Hello Sathish,

You could use VLOOKUP as Array Formula with help of IF to return multiple values

=VLOOKUP($A2,IF(ISNA(MATCH(Database1!$B$2:$B$7,$A2:A2,0)),Database1!$A$2:$B$7),2,0)