Hi
When you say 'it says the formula contains an error', what is Excel actually
returning? Does it say #N/A, or #NAME or what?
The formula looks OK to me. It might be that your '123' is actually text,
rather than a number, Try:
=VLOOKUP("123",A1:B4,2,FALSE)

--
Andy.


"khers Field" wrote in message
...
On 28.04.2005 09:54, Andy B wrote:
Hi
Try using VLOOKUP()
=VLOOKUP(123,A1:B4,2,FALSE)

it says the formula contains an error