Excellent. Work perfect. One more Niek, to keep the formula static besides
the
lookup value:

=VLOOKUP(C2,Sheet1!A2:D326,1,FALSE)

"Niek Otten" wrote:

The cell was formatted as Text when you entered the function.
Just re-formatting is not enough; format as number or General AND re-enter
the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cmc4" wrote in message
...
The formula returns a result in the wizard but will not display it on the
worksheet? No luck with the Show Formula button.