Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I get this done
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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) "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 |
#4
|
|||
|
|||
A non array alternative:
=VLOOKUP("Plan "&B11,A2:C4,MATCH(B10,A1:C1,0),0) Biff "Biff" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|