Excel Formulas

L

Loss

Hi All, I would like to do a Vlookup and a Hlookup
simulteanously done. is it possible

currently i am doing a Vlookup only, and i refrence the
columns by doing something like $A$D,2,False..

I do not want to do this anymore. Is there any way
 
D

Dave Peterson

So you want to pick out the correct column by matching on the header--and same
thing for the correct row?

Here's a formula stolen from Peo Sjoblom (and others):

=INDEX(Table,MATCH(A1,INDEX(Table,,1),0),MATCH(B1,INDEX(Table,1,),0))

If you create a range name referring to your cross reference table
(Insert|Name|Define) and call it Table, it'll make your typing life a little
easier. (But you could use the address (Sheet2!$a$1:$x$9999) in place of Table
in the formula.

And A1 will hold the value to match on the column (to get the right row) and B1
will be used to get the correct column.
 
Top