MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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"