adamacme
New Member
- Joined
- Jun 12, 2015
- Messages
- 6
Hi all,
I have a worksheet with 5 columns that has a list of values based off of bed/bath combinations. For Example:
A B C D E
Beds Baths Linens Consumables Totals
1 1 1 9.75 15.10 24.85
2 3 2 13.5 19.45 32.95
3 4 4 26.6 32.10 58.70
4 4 2 23.5 29.50 53.00
5 2 2 11.5 17.65 29.15
I have 2 cells in a row that have the specific Bed/Bath combo, and want to be able to give the total of the linens and consumables based off the two values.
so in another sheet I have:
Bed Bath
2 2
I have tried this VLOOKUP, but it doesn't seem to work: =VLOOKUP(Sheet2!I2:J2, Sheet2!$A$2:$F$34, 4, FALSE)
I think the problem is that I have two cells that need to be exactly matched in the above range, and VLOOKUP only seems to be able to successfully match one cell as the criteria.
So should I use the SUMIF Formula? And if so how would I type it out so it works? Thanks
I have a worksheet with 5 columns that has a list of values based off of bed/bath combinations. For Example:
A B C D E
Beds Baths Linens Consumables Totals
1 1 1 9.75 15.10 24.85
2 3 2 13.5 19.45 32.95
3 4 4 26.6 32.10 58.70
4 4 2 23.5 29.50 53.00
5 2 2 11.5 17.65 29.15
I have 2 cells in a row that have the specific Bed/Bath combo, and want to be able to give the total of the linens and consumables based off the two values.
so in another sheet I have:
Bed Bath
2 2
I have tried this VLOOKUP, but it doesn't seem to work: =VLOOKUP(Sheet2!I2:J2, Sheet2!$A$2:$F$34, 4, FALSE)
I think the problem is that I have two cells that need to be exactly matched in the above range, and VLOOKUP only seems to be able to successfully match one cell as the criteria.
So should I use the SUMIF Formula? And if so how would I type it out so it works? Thanks
Last edited: