Trouble with my formula
 

=PRODUCT(I478,VLOOKUP(G478,$AV$365:$AW$389,2))This formula is correct the
data it reads from is correct and yet there are 5 or 6 error inputs. This is
what happens when I input numbers
8x6 167
8x8 167
10x6 22.50
10x10 N/A
12x6 29

Etc...
I have a list of 22 sizes in column AV and their prices in column AW Most of
them work and fine but the first two read the prices of the last one. And
some of the earlier ones read n/a. But then it smooths and works for the
remaining ones and I can't figure out why.
The multiple that it is being multiplied by is an if formula
=IF(N478="Aluminum",1,IF(N478="Steel",0.9))

Now I have used this formula multiple times in the worksheet and have used
the mutiple in those formulas as well some of them using upwards of 40
variables.
What would be causing this and why?

Thanks

Trouble with my formula
 

Try it like this:

I478*VLOOKUP(G478,$AV$365:$AW$389,2,0)

--
Biff
Microsoft Excel MVP


"Excluxe" wrote in message
...
=PRODUCT(I478,VLOOKUP(G478,$AV$365:$AW$389,2))This formula is correct the
data it reads from is correct and yet there are 5 or 6 error inputs. This
is
what happens when I input numbers
8x6 167
8x8 167
10x6 22.50
10x10 N/A
12x6 29

Etc...
I have a list of 22 sizes in column AV and their prices in column AW Most
of
them work and fine but the first two read the prices of the last one. And
some of the earlier ones read n/a. But then it smooths and works for the
remaining ones and I can't figure out why.
The multiple that it is being multiplied by is an if formula
=IF(N478="Aluminum",1,IF(N478="Steel",0.9))

Now I have used this formula multiple times in the worksheet and have used
the mutiple in those formulas as well some of them using upwards of 40
variables.
What would be causing this and why?

Thanks

Trouble with my formula
 

Thanks for the advice it worked

"T. Valko" wrote:

Try it like this:

I478*VLOOKUP(G478,$AV$365:$AW$389,2,0)

--
Biff
Microsoft Excel MVP


"Excluxe" wrote in message
...
=PRODUCT(I478,VLOOKUP(G478,$AV$365:$AW$389,2))This formula is correct the
data it reads from is correct and yet there are 5 or 6 error inputs. This
is
what happens when I input numbers
8x6 167
8x8 167
10x6 22.50
10x10 N/A
12x6 29

Etc...
I have a list of 22 sizes in column AV and their prices in column AW Most
of
them work and fine but the first two read the prices of the last one. And
some of the earlier ones read n/a. But then it smooths and works for the
remaining ones and I can't figure out why.
The multiple that it is being multiplied by is an if formula
=IF(N478="Aluminum",1,IF(N478="Steel",0.9))

Now I have used this formula multiple times in the worksheet and have used
the mutiple in those formulas as well some of them using upwards of 40
variables.
What would be causing this and why?

Thanks

Trouble with my formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Excluxe" wrote in message
...
Thanks for the advice it worked

"T. Valko" wrote:

Try it like this:

I478*VLOOKUP(G478,$AV$365:$AW$389,2,0)

--
Biff
Microsoft Excel MVP


"Excluxe" wrote in message
...
=PRODUCT(I478,VLOOKUP(G478,$AV$365:$AW$389,2))This formula is correct
the
data it reads from is correct and yet there are 5 or 6 error inputs.
This
is
what happens when I input numbers
8x6 167
8x8 167
10x6 22.50
10x10 N/A
12x6 29

Etc...
I have a list of 22 sizes in column AV and their prices in column AW
Most
of
them work and fine but the first two read the prices of the last one.
And
some of the earlier ones read n/a. But then it smooths and works for
the
remaining ones and I can't figure out why.
The multiple that it is being multiplied by is an if formula
=IF(N478="Aluminum",1,IF(N478="Steel",0.9))

Now I have used this formula multiple times in the worksheet and have
used
the mutiple in those formulas as well some of them using upwards of 40
variables.
What would be causing this and why?

Thanks