If Statement with VLookup

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.
 
T

Toppers

Something like:

=VLOOKUP(1234,$A$2:$C$4,2,FALSE)/VLOOKUP(1234,$A$2:$C$4,3,FALSE)

Replace 1234 by cell containing the Product #

A:C contains your lookup table

A=Product #
B=Volume
C=ibs per unit

HTH
 
D

Don Guillett

If i properly understand. one way if
=100000/200
=vlookup(1234,b1:d100,2)/vlookup(1234,b1:d100,3)
 
S

Shams

Toppers,
Thanks for your email from last week. You almost answered my question!!
Let me clarify my original query:

My lookup table (Sheet 1) contains:
A: Product #
B: Total numbers of lbs.

My main table (Sheet 2) [where the vlookup function resides] has the
following:

A: Product #
B: # of Units

So, let's say, in Column C (in Sheet 2) I am trying to write a vlookup
formula that will look up Product # in Sheet 1 and return the Total number of
lbs. I want to incorporate the additional formula where if it finds the
lookup value then it divides the Total number of lbs. by the # of units.
That's what I am looking for: Lookup A1 in Sheet1 A:B, return B but divide it
by # of units.

Hope this helps. Thanks .

Regards,
Shams.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top