Formula to Extract value on 3 column based on two conditions
 

I have an xml map on a spreadsheet.

There are three columns.

I'd like to find a formula that does the following.

1 A 5
1 B 7
1 C
1 D 3
2 E 6
2 F 8
2 G
2 H 0

Saying that these three columns are my columns on my spreadsheet.

I am currently able to use vlookup on column B to get to the number on
column C however I also want to add a condition that the value on
Column B has to be within a range in Column A.

Help appreciated.


--
wayliff
------------------------------------------------------------------------
wayliff's Profile: http://www.excelforum.com/member.php...o&userid=29860
View this thread: http://www.excelforum.com/showthread...hreadid=500825