jimdegeorge
New Member
- Joined
- May 13, 2010
- Messages
- 7
Hi
I have two tables (Table1 and Table2) on 2 different tabs (Sheet1 and Sheet2, respectively).
Table1
<tbody>
</tbody>
Table2
<tbody>
</tbody>
When NAME and CITY from Table1 are found on Table2, I want to save Table2's DISTRICT value in the appropriate Table1 DISTRICT cell.
This is the desired Table1 result:
<tbody>
</tbody>
I've tried these formulas in Table1 DISTRICT...
=IF(Table1[@[Name]:[City]]=Table2[@[Name]:[City]],Table2[@District],""), but this returns #VALUE !
=If(VLOOKUP(Table1[@[Name]:[City]],Table2[[Name]:[City]],C,FALSE),Table2[@District],""), but I can't get it formatted correctly.
I'd really appreciate any help!
Thanks!
Jim
I have two tables (Table1 and Table2) on 2 different tabs (Sheet1 and Sheet2, respectively).
Table1
Name | City | Line | District |
James | Boston | Hard Goods | |
John | Los Angeles | Soft Goods | |
William | Baltimore | Soft Goods | |
Harold | Miami | Hard Goods |
<tbody>
</tbody>
Table2
Name | City | District |
James | Boston | North East |
John | Los Angeles | West |
William | Baltimore | Central East |
Harold | Miami | South East |
<tbody>
</tbody>
When NAME and CITY from Table1 are found on Table2, I want to save Table2's DISTRICT value in the appropriate Table1 DISTRICT cell.
This is the desired Table1 result:
Name | City | Line | District |
James | Boston | Hard Goods | North East |
John | Los Angeles | Soft Goods | West |
William | Baltimore | Soft Goods | Central |
Harold | Miami | Hard Goods | South East |
<tbody>
</tbody>
I've tried these formulas in Table1 DISTRICT...
=IF(Table1[@[Name]:[City]]=Table2[@[Name]:[City]],Table2[@District],""), but this returns #VALUE !
=If(VLOOKUP(Table1[@[Name]:[City]],Table2[[Name]:[City]],C,FALSE),Table2[@District],""), but I can't get it formatted correctly.
I'd really appreciate any help!
Thanks!
Jim