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

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.



Posted by Mark W. on January 14, 2002 11:40 AM

Suppose A1:C4 contains...


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"