S
Shams
Folks,
I have the following scenario:
I am doing a Vlookup (by Product #) to bring in Volume in Lbs. Now, I need
to convert this into number of units. So for example: If Product # 1234 has
a total volume of 1,000 lbs. and I know that each bag of this product is 5
lbs. then total number of bags is 200.
Is there a way I can combine these two functions in one cell. So, do a
Vlookup and if it finds the Volume then divide it by #of lbs. per unit:
Product SKU Volume (in lbs.) lbs per Unit
Vlookup Cell
1234 100,000 200
3256 125,000 500
Hope to hear back from you soon. Thanks.
Shams.
I have the following scenario:
I am doing a Vlookup (by Product #) to bring in Volume in Lbs. Now, I need
to convert this into number of units. So for example: If Product # 1234 has
a total volume of 1,000 lbs. and I know that each bag of this product is 5
lbs. then total number of bags is 200.
Is there a way I can combine these two functions in one cell. So, do a
Vlookup and if it finds the Volume then divide it by #of lbs. per unit:
Product SKU Volume (in lbs.) lbs per Unit
Vlookup Cell
1234 100,000 200
3256 125,000 500
Hope to hear back from you soon. Thanks.
Shams.