akswartz85
New Member
- Joined
- Mar 31, 2010
- Messages
- 49
I have one table with unique identifiers and different years. I want to pull amounts from additional tabs into the cells only labeled with the $ below:
Tab name: MERGED
<tbody>
</tbody>
Additional tabs (each ID may be listed 1+ times):
Tab name: ALL AMOUNTS
<tbody>
</tbody>
I'd like to pull the amount into the proper year column by ID. Ideally, it would look like:
<tbody>
</tbody>
I was thinking I could write an IF(Vlookup)
=if('all amounts'$b2="2015",vlookup('merged'$a2,'all amounts'$a:$c,3,false),"No amount")
(forgive me if I forgot any formatting, I'm making this dataset up bc my actual data has identifying info)
But when I drag the formula down, I just get "no amount" (i.e. the if failed).
Thoughts? My head is spinning.
Tab name: MERGED
Unique ID | 2015 | 2016 | 2017 |
1234A | $ | $ | $ |
4567B | $ | $ | $ |
9038B | $ | $ | $ |
9038J | $ | $ | $ |
<tbody>
</tbody>
Additional tabs (each ID may be listed 1+ times):
Tab name: ALL AMOUNTS
Unique ID | YEAR | Amount |
1234A | 2015 | 342 |
1234A | 2016 | 394 |
4567B | 2017 | 390 |
4567B | 2015 | 908 |
9038J | 2017 | 908 |
9038J | 2016 | 3221 |
9038B | 2017 | 9033 |
<tbody>
</tbody>
I'd like to pull the amount into the proper year column by ID. Ideally, it would look like:
Unique ID | 2015 | 2016 | 2017 |
1234A | $342 | $394 | No amount |
4567B | $908 | No amount | $390 |
9038B | No amount | No amount | $9033 |
9038J | No amount | $3221 | $908 |
<tbody>
</tbody>
I was thinking I could write an IF(Vlookup)
=if('all amounts'$b2="2015",vlookup('merged'$a2,'all amounts'$a:$c,3,false),"No amount")
(forgive me if I forgot any formatting, I'm making this dataset up bc my actual data has identifying info)
But when I drag the formula down, I just get "no amount" (i.e. the if failed).
Thoughts? My head is spinning.