VAre Fractions allowed in VLookup Tables or must they be converedtedfor useage?

R

Realitygdk

The formula is supposed to be saying multiply Column (G), which in
this case has a 1/16 in it, and multiply number by Column C which has
a 2 in it, and then place that number in Column (I). The Column (J)
is to Look into the named range Fraction and enter the corresponding
weight label "ounce" or "pounds", but since I cannot make the Look Up
work I have enter the is greater or not greater to hopefully arrive at
the same correct label..


VLOOKUP Table Fraction
VLOOKUP Table Decimal
VLOOKUP Table D2ecimal

A B C D E F G H I J
Name Number At Fraction Fraction Total Total
Of Of Postage Dollars Weight Weight Weight Weight
Department Pieces Rate Of Amount Foz_Fib Ftype Foz_Fib Ftype
Date Dept Pieces Rate Amt Fozib Flabel Fozib Flabel
January 1, 2008 Administration 2 $0.41 $0.82 1/16 0 #VALUE!
#VALUE!

The following formula is in Column (I):

=IF(ISERROR(VLOOKUP(D14,FRate,2,FALSE)),0,(VLOOKUP(D14,FRate,2)))
and this formula listed below is in Column (J)

=IF(I8<=0.8125,"ounce","pounds")

My problems are as follows:
1/16 equals .41 in the Named Range called Fraction and here it should
be multiply by the 2 from the (J) Column and then that value is to be
looked up in the named ranged called Fraction

The second formula is then to Look Up the value in the (J) Column and
then assign an ounce or pound depending of if the weight is under 16
ounces or over.

Any help or suggestion is mot appreciated, as I have been at this for
awhile and the formula seemed to be stating what I had just made
referenced to but the results are not what I am expecting.
 
R

Realitygdk

On Dec 19, 12:54 pm, (e-mail address removed) wrote:
The formula is supposed to be saying multiply Column (G), which in
this case has a 1/16 in it, and multiply number by Column C which has
a 2 in it, and then place that number in Column (I). The Column (J)
is to Look into the named range Fraction and enter the corresponding
weight label "ounce" or "pounds", but since I cannot make the Look Up
work I have enter the is greater or not greater to hopefully arrive at
the same correct label..


VLOOKUP Table Fraction
VLOOKUP Table Decimal
VLOOKUP Table D2ecimal

A B C D E F G H I J
Name Number At Fraction Fraction Total Total
Of Of Postage Dollars Weight Weight Weight Weight
Department Pieces Rate Of Amount Foz_Fib Ftype Foz_Fib Ftype
Date Dept Rate Amt Fozib Flabel Fozib Flabel

January 1, 2008Administration 2 $0.41 $0.82 1/16 0 #VALUE!
#VALUE!

The following formula is in Column (I):

=IF(ISERROR(VLOOKUP(D14,FRate,2,FALSE)),0,(VLOOKUP(D14,FRate,2)))
and this formula listed below is in Column (J)

=IF(I8<=0.8125,"ounce","pounds")

My problems are as follows:
1/16 equals .41 in the Named Range called FRate and here it should be
multiply by the 2 from the (J) Column and then that value is to be
looked up in the named ranged called FRate

The second formula is then to Look Up the value in the (J) Column and
then assign an ounce or pound depending of if the weight is less than
16 ounces or over.

Any help or suggestion is most appreciated, as I have been at this for
awhile and the formula seemed to be stating what I had just made
referenced to but the results are not what I am expecting.

My apologies to this Group for rushing my request that has resulted in
a table that I cannot seem to reproduce correctly: With your
permission I would like to re-submit with corrections--Lookup Table is
FRate, rather than Fraction, unfortunately, I am unable to submit a
better formatted table for one.

Thank you for sharing your time and experiences with me in this
personal matter.

George
 
R

Realitygdk

On Dec 19, 12:54 pm, (e-mail address removed) wrote:
The formula is supposed to be saying multiply Column (G), which in
this case has a 1/16 in it, and multiply number by Column C which has
a 2 in it, and then place that number in Column (I). The Column (J)
is to Look into the named range Fraction and enter the corresponding
weight label "ounce" or "pounds", but since I cannot make the Look Up
work I have enter the is greater or not greater to hopefully arrive at
the same correct label..

VLOOKUP Table Fraction
VLOOKUP Table Decimal
VLOOKUP Table D2ecimal

A B C D E F G H I J
Name Number At Fraction Fraction Total Total
Of Of Postage Dollars Weight Weight Weight Weight
Department Pieces Rate Of Amount Foz_Fib Ftype Foz_Fib Ftype
Date Dept Rate Amt Fozib Flabel Fozib Flabel

January 1, 2008Administration 2 $0.41 $0.82 1/16 0 #VALUE!
#VALUE!

The following formula is in Column (I):

=IF(ISERROR(VLOOKUP(D14,FRate,2,FALSE)),0,(VLOOKUP(D14,FRate,2)))
and this formula listed below is in Column (J)

=IF(I8<=0.8125,"ounce","pounds")

My problems are as follows:
1/16 equals .41 in the Named Range called FRate and here it should be
multiply by the 2 from the (J) Column and then that value is to be
looked up in the named ranged called FRate

The second formula is then to Look Up the value in the (J) Column and
then assign an ounce or pound depending of if the weight is less than
16 ounces or over.

Any help or suggestion is most appreciated, as I have been at this for
awhile and the formula seemed to be stating what I had just made
referenced to but the results are not what I am expecting.

My apologies to this Group for rushing my request that has resulted in
a table that I cannot seem to reproduce correctly: With your
permission I would like to re-submit with corrections--Lookup Table is
FRate, rather than Fraction, unfortunately, I am unable to submit a
better formatted table for one.

Thank you for sharing your time and experiences with me in this
personal matter.

George

Sorry I not sure how to delete this post and start another without
duplicating a post.

I needed to state that I am using Excel 2007--[Vistal Ultimate Office
and OS System.]

George
 

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