beckiepops2
New Member
- Joined
- Feb 14, 2016
- Messages
- 4
Hi! Thank you so much for having this site. Not sure what I would do without all of you!
Here is the data:
-- removed inline image ---
I need to write a function or formula in the RESULT column. But the formula needs to look in the Occasion column and find it's MATCH in the Category column and then when it finds a match, I need it to calculate cost/1000 * Cards Sold.
My data has about 3000 rows, so doing it the way I have done it would not be feasible, that's why I'm hoping there is either a MATCH function or LOOKUP function that can do this instead.
Thank you!
Here is the data:
-- removed inline image ---
I need to write a function or formula in the RESULT column. But the formula needs to look in the Occasion column and find it's MATCH in the Category column and then when it finds a match, I need it to calculate cost/1000 * Cards Sold.
My data has about 3000 rows, so doing it the way I have done it would not be feasible, that's why I'm hoping there is either a MATCH function or LOOKUP function that can do this instead.
Thank you!