I have been wasting my time on this for way too long and just cant work out the solution... so its time to ask the pros.
I have the following table on a worksheet:
representativeTable
. | ..A.. | ....B.... |
--+-------+-----------+
1 | NAME. | COMPANY.. |
2 | John. | Google... |
3 | Bill. | Adobe.... |
4 | Bob.. | Adobe.... |
5 | Tim.. | Microsoft |
6 | Jerry | Google... |
7 | Anne. | Microsoft |
Then on a separate worksheet I have listed a set of awards categories:
. | ......A...... | ....B.... | ...........C........... |
--+---------------+-----------+-------------------------+
1 | AWARD........ | COMPANY.. | PERSON ACCEPTING AWARD. |
2 | First Place.. | Adobe.... | ....................... |
3 | Second Place. | Google... | ....................... |
4 | Third Place.. | Microsoft | ....................... |
For the column called "PERSON ACCEPTING AWARD" I would like to be able to get the Data Validation tool to see the company who won the award for that row and by referencing the representativeTable work out who works for that company and only display the names of that companies representatives.
Thanks
Bookmarks