Click here to reset your password. You MUST have a valid e-mail address so that you may receive the instructions to complete the reset.

If this is your first visit, be sure to check out the Board FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.

Thanks Aladin I think we could be on the right track although I think I might be trying to do something almost impossible.

Although if anyone can figure it out it is you and others here.

I tried to use the sumproduct in the same column as the number I am trying to lookup and I get circular refs.

Essentially some of the rows have pricing I want to use (like the $400) when related to 'dog'. The other rows I need to pull that pricing when the other columns match (five, car) but do not match 'dog'.

i am trying in a seperate column, but that can be a pain since i have about 12 diff column to do this to.

If I understand you correctly, if the entry in the second column of rows 2,3,and 4th column is 'five', then you would want the corresponding entry in the 4th column
to be the same as the entry in the 4th column of row 1 … if it is so, then use
the following formula in the 4th column of rows 2,3, and 4 --

=VLOOKUP("five",{"five","car",400},3)

If I have not understood you correctly, or it does not work for you, please explain a little further ... and let us take it from there!

I need the $400 in other rows if column 2 AND 3 match.
One additional problem is that the $400 is not constant.

Let me try to explain a little further with more specific data.
I have regional data (5 regions) and I have north america pricing. For any of the other regions (not north america) I want to take the NA pricing and factor up or down from it. I need to take the NA pricing for similar data. I need to take the NA price for a 12-inch TV and use that to factor the price for a Europe 12-inch TV. and NA 14-inch TV to get the Europe 14-inch price.

I have many products and lots of pricing so I wanted something pretty dynamic and I just dont know if I can get it.

My thought is to check and see if a cell is north america, if so then use than pricing. If not then check other characteristics and make sure they are similar to use for the comparison.

I believe your data is too extensive to explain in a few words on the board. You should either post some real data on the board so the viewers can bite into the real thing. If you care to email your file to me, I will be glad to look at it and help if i can.