formula for two tables
Posted by I MEHTA on January 14, 2002 9:18 AM
from a table (with row & col headings) i want to lookup certain value & place it in another table (with col & row headings).
Pl advise.
mehtai at the rate bharatpetroleum.com
Posted by Aladin Akyurek on January 14, 2002 10:27 AM
Have a look at VLOOKUP and the combined use of INDEX and MATCH.
You could also post some sample data, along with expected results.
Aladin
=======
Posted by Mark W. on January 14, 2002 11:40 AM
Suppose A1:C4 contains...
{"","X","Y"
;"Red",3,5
;"Green",4,1
;"Yellow",2,8}
The formula, =Red X, returns 3 and the formula,
=Yellow Y, returns 8.
Posted by Juan Pablo G. on January 14, 2002 11:57 AM
For this to work the checkbox in Tools - Options, Calculate, "Accept headings in formulas" must be checked.
Juan Pablo G.
Posted by Mark W. on January 14, 2002 1:46 PM
Sooo TRUE! (nt)
Juan Pablo G. : Suppose A1:C4 contains... : {"","X","Y"
