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.