Not sure what you mean, but maybe this:

=VLOOKUP(C2,Sheet1!$A$2:$D$326,1,FALSE)

You can easily change to absolute references by pressing F4 when you are
entering or editing the cell references.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"cmc4" wrote in message
...
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.