What's wrong with this Formula?.

[israellawndale]

Hello,

I'll make my problem short so any can help me out...


I have data on a master sheet with all employees information. I have a second worksheet called "groups". Under the master sheet people are assigned group numbers.. I would like for my "groups" worksheet to copy only the emplyoees that are under group "4" from the master sheet. .. But I want the names of the employees from that group to copy ..I created a name range called "personaldata" . the names of the employees are on columns "1" and "2"

I did something like this. but it's not working.


=VLOOKUP('Master Sheet'!D:D="4",PersonalData,1&2,0)

 

[trunten]

=VLOOKUP('Master Sheet'!D:D="4",PersonalData,1,0)&VLOOKUP('Master Sheet'!D:D="4",PersonalData,2,0)

 

[T. Valko]

Hello,

I'll make my problem short so any can help me out...


I have data on a master sheet with all employees information. I have a second worksheet called "groups". Under the master sheet people are assigned group numbers.. I would like for my "groups" worksheet to copy only the emplyoees that are under group "4" from the master sheet. .. But I want the names of the employees from that group to copy ..I created a name range called "personaldata" . the names of the employees are on columns "1" and "2"

I did something like this. but it's not working.


=VLOOKUP('Master Sheet'!D:D="4",PersonalData,1&2,0)

Sounds like you want to do something like this:

http://www.mrexcel.com/forum/showpost.php?p=2696961&postcount=3

 

[israellawndale]

thanks for your help!1

 

[israellawndale]

thanks for your help!!1

 

[Ormus]

Highly recomend instead of using Vlookup or Hlookup instead do the Index and Match combination.

While nothing "wrong" with vlookup, Index and Match is my prefered way to do lookups due to how easy it is to break vlookup (like inserting a col in the middle of the vlookup reference).

Can get more info at:
http://www.mrexcel.com/articles/excel-vlookup-index-match.php

 

[T. Valko]

thanks for your help!!1

You're welcome!

 

[israellawndale]

Highly recomend instead of using Vlookup or Hlookup instead do the Index and Match combination.

While nothing "wrong" with vlookup, Index and Match is my prefered way to do lookups due to how easy it is to break vlookup (like inserting a col in the middle of the vlookup reference).

Can get more info at:
http://www.mrexcel.com/articles/excel-vlookup-index-match.php

thanks so much for your suggestion. I will surely look into this..THANK YOU, THANK YOU.