Three Column Lookup-Use Match and Index?

B

bfriederichs

Got a little problem, making a spreadsheet to do an interpolation o
conductor sag data taken from a very expensive program. Here's m
problem, due to the nature of the data, I need to do a three colum
lookup function. Now, I tried expanding
=INDEX(Place to look
MATCH(Value_1,&Value_2,&Value_3,V1_Range&V2_Range&V3_Range, 0))

That's an expansion of something I figured out for a two column a fe
months ago, thought I could just expand it by one column, but obviousl
I'm mistaken.

Any thoughts?

Oh, and my VBA is so rusty it doesn't even move
 
K

kfotedar

It will work but the whole formula has to be enclosed in an array.
i.e. after you are done constructing the formula you'll have to ente
:

CTRL+SHIFT+Enter.

Please find my attached spreadsheet with an example. I think it shoul
work for you.

Kavi

Attachment filename: array_indexformula.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63399
 
P

Peo Sjoblom

You have to enter that formula with ctrl + shift & enter

another variant is

=INDEX(Place to
look,MATCH(1,(V1_Range=Value_1)*(V2_Range=Value_2)*(V3_Range=Value_3),0))

also array entered

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top