kcochran12
New Member
- Joined
- Apr 2, 2018
- Messages
- 3
Using Excel 2007
Hello,
I am trying to return the amount from table 2 to table 1. I've used the following formula, =index(A2:A9,match(a2,I2:I9,0)), in B2 of table 1. I've copied down the formula but once the account that I need is in a different column I get the #N/A error. I need the formula to then check the other lookup columns in table 2 for the account numbers and return the amount that is in its respective row. Please help.
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Hello,
I am trying to return the amount from table 2 to table 1. I've used the following formula, =index(A2:A9,match(a2,I2:I9,0)), in B2 of table 1. I've copied down the formula but once the account that I need is in a different column I get the #N/A error. I need the formula to then check the other lookup columns in table 2 for the account numbers and return the amount that is in its respective row. Please help.
Table 1
Account | Amount |
1234 | |
2345 | |
3456 | |
4567 | |
5678 | |
6789 | |
7890 | |
8901 | |
9012 |
<tbody>
</tbody>
Table 2
Amount | Data 1 | Data 2 | Data 3 | Data 4 | lookup 1 | lookup 2 | lookup 3 | lookup 4 |
10 | 1234 | |||||||
20 | 2345 | |||||||
30 | 3456 | |||||||
40 | 4567 | |||||||
50 | 5678 | |||||||
60 | 6789 | |||||||
70 | 7890 | |||||||
80 | 8901 | |||||||
90 | 9012 |
<tbody>
</tbody>