I have a table in a different workbook that I enter employee info. I have a NameID, Name, email,phone and state columns. I use a data validation drop down for the NmaeID and then vlookup to speed up the data entry on a different workbook 1. The list of employees will be very long and I was hoping to use the state column to shorten the NameID drop down. One cell for the criteria state=TX and then employees in that state would show up in the drop down as a choose.
Workbook 1 sheet 1
<tbody>
</tbody>
<tbody>
</tbody>
I use vlookup to fill in Name, Email, phone off of workbook 2
Workbook 2 sheet 1
<tbody>
</tbody>
Thanks for your help
Workbook 1 sheet 1
state |
TX |
<tbody>
</tbody>
NameID | Name | Phone | |
smithJ= only show TX employees as a choice | John Smith | 233232323 | smithj@gmail.com |
<tbody>
</tbody>
I use vlookup to fill in Name, Email, phone off of workbook 2
Workbook 2 sheet 1
NameID | Name | Phone | State | |
smithJ | John Smith | smithj@gmail.com | 23232323223 | TX |
HallT | Tim Hall | HallTgmail.com | 32323222323 | CA |
<tbody>
</tbody>
Thanks for your help