how do I get this done

[pgruening]

If anyone can help me with this I'd greatly appreciate it


If I have some data such as

Single Family
Plan A 2.00 4.00
Plan B 3.00 5.00
Plab C 4.00 6.00


and also have
status single
plan A
cost X what formula for X will look at the data abov
and return the value 2.00

Thank

 

[Biff]

Hi!

Assume:

A1...............B1...............C1
..................Single..........Family
Plan A........2.00............4.00
Plan B........3.00............5.00
Plan C........4.00............6.00

A10...............B10
Status...........Single
Plan................A
Cost.............Formula

Formula entered as an array using the key combo of CTRL,SHIFT,ENTER:

=VLOOKUP(B11,RIGHT(A2:C4,1),MATCH(B10,A1:C1,0),0)

Biff

 

[Bob Phillips]

Not sure about the exact layout of the data, but maybe

=INDEX($B$2:$B$20,MATCH("Plan "&M1,$A$2,$A$20,0)

where M1 holds the A.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Biff]

A non array alternative:

=VLOOKUP("Plan "&B11,A2:C4,MATCH(B10,A1:C1,0),0)

Biff