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

"pgruening" wrote
in message ...

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 above
and return the value 2.00

Thanks


--
pgruening
------------------------------------------------------------------------
pgruening's Profile:
http://www.excelforum.com/member.php...o&userid=26011
View this thread: http://www.excelforum.com/showthread...hreadid=393689