Comparing for the correct value

[Olly]

I have a spreadsheet were i need the computer to compare the value in
cell F24, with the following values in the worksheet Basic Details in
column A and then display the correct value from the B column:

A B
1 >1000 £260.00
2 >1001<2000 £550.96
3 >2001<3000 £603.12
4 >3000 £0.00

 

[Peo Sjoblom]

One possible way

=LOOKUP(F24,{1;1001;2001;3001},{260;550.96;603.12;0})

 

[Olly]

Thanks a knew it was something like that, but i could not work it out.