urban_player
New Member
- Joined
- Feb 22, 2019
- Messages
- 14
Hi,
I am trying to achieve the following:
I have a row of data with multiple columns. I want to look up Column C for a value in another table, and if that value is found, i want it to return the contents of Column A (second table).
Column C is missing a field, i want to essentially find Cell B2 in table 2, if there is a match, return the missing blank in Table 1 C3 with the contents from table 2.
Table 1
A B C D E F
1 Jack jack@who.com XXX
2 Bob bob@who.com XXX
3 Dave dave@who.com
4 Jake jake@who.com XXX
5 Bob
Table 2
A B C D E F
1 Jack jack@who.com XXX
2 Bob bob@who.com XXX
3 Dave dave@who.com XXX
4 Jake jake@who.com XXX
Any help would be appreciated.
many thanks!
I am trying to achieve the following:
I have a row of data with multiple columns. I want to look up Column C for a value in another table, and if that value is found, i want it to return the contents of Column A (second table).
Column C is missing a field, i want to essentially find Cell B2 in table 2, if there is a match, return the missing blank in Table 1 C3 with the contents from table 2.
Table 1
A B C D E F
1 Jack jack@who.com XXX
2 Bob bob@who.com XXX
3 Dave dave@who.com
4 Jake jake@who.com XXX
5 Bob
Table 2
A B C D E F
1 Jack jack@who.com XXX
2 Bob bob@who.com XXX
3 Dave dave@who.com XXX
4 Jake jake@who.com XXX
Any help would be appreciated.
many thanks!