Thread
:
If Statement with VLookup
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
If Statement with VLookup
If i properly understand. one way if
=100000/200
=vlookup(1234,b1:d100,2)/vlookup(1234,b1:d100,3)
--
Don Guillett
SalesAid Software
"Shams" wrote in message
...
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett