I am trying to take a list of Product Numbers in Table 1 and put a Type description next to it based on which column the item number appears in a separate table. I can get the separate IF/Vlookup statements to work individually, but not all together.
Formula I'm using that doesn't work:
=IF(A3=VLOOKUP(A3,'Table 2'!$A$10:$A$11,1,FALSE),"PROMO",(IF(A3=VLOOKUP(A3,'Table 2'!$C$2:$C$16,1,FALSE),"BURNDOWN","STOCK")))
Example of data:
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Any help would be much appreciated!
Formula I'm using that doesn't work:
=IF(A3=VLOOKUP(A3,'Table 2'!$A$10:$A$11,1,FALSE),"PROMO",(IF(A3=VLOOKUP(A3,'Table 2'!$C$2:$C$16,1,FALSE),"BURNDOWN","STOCK")))
Example of data:
Table 1 | ||
ProdNbr | Desc | Type |
97609 | Peanuts | PROMO |
97602 | Popcorn | |
97415 | Soda | |
97451A | Licorice | |
Table 2 | ||
Promo | Stock | Burndown |
97609 | 97602 | 97415 |
97451A | 97425 | 97599 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Any help would be much appreciated!