IF statement help

[smart analyst]

Hi,

I need help determining the correct formula to use for something like this:

If something falls between a date range, and has a unique ID, use a certain number?


If my data is organized in a way like this:

[TABLE="width: 244"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]From[/TD]
[TD]To[/TD]
[TD]ID[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]31-Jan[/TD]
[TD]28-Feb[/TD]
[TD]AF4955[/TD]
[TD]54.35[/TD]
[/TR]
[TR]
[TD]1-Apr[/TD]
[TD]31-May[/TD]
[TD]C4849[/TD]
[TD]33.45[/TD]
[/TR]
</tbody>[/TABLE]



What would be the best way to set up a table to effortlessly display all the information?

 

[SteveO59L]

I would be inclined to tabulate and use vlookup()