Posted by Bernadette Hall on December 03, 2001 1:50 AM
my spreadsheet looks up two values from different cells to return a value for one. confused? the company sells different kinds of stone, and different rates for different thickness. the lookup formula looks something like this: [thanks to the guy who helped me with this part :)]
where a2 is the name of stone eg blue, and c2 the thickness. the other part is a large table.
the problem i am having with this, is that although excel returns a value, it is often the wrong one, usually whatever is at the bottom of the table, and i have no idea why!
if u can help me with this i would be very grateful, because i am really tearing my hair out. i can send u an abbreiviated copy of the spreadsheet, so u can see for yourself.