iamanexcelnoob
Board Regular
- Joined
- Jun 15, 2016
- Messages
- 71
hi all, i am looking to match two separate criteria listed on tab 1 to a table of rates on tab 2. i would like to find the rate and then multiply by another number back on tab 1.
hopefully that makes sense. i assume an index, match would work, but not sure how to take advantage of 2 criteria here and then multiply all in the same formula.
thanks!
hopefully that makes sense. i assume an index, match would work, but not sure how to take advantage of 2 criteria here and then multiply all in the same formula.
thanks!