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

One possible way

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

--

Regards,

Peo Sjoblom


"Olly" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

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

"Peo Sjoblom" <(E-Mail Removed)> wrote in message news:<(E-Mail Removed)>...
> One possible way
>
> =LOOKUP(F24,{1;1001;2001;3001},{260;550.96;603.12;0})
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "Olly" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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