hi and thanks for the response. I actually tried changing the format
and using the absolute value. Sorry I didn't mention that before.

jazzydwit wrote:
Hi. Can someone tell me why I get the Vlookup formula in the cell I am
trying to pull data into? I tried copying and pasting data in new
workbook, but the formula still shows in the cell.
thanks. This is what shows in my cell after I perform the vlookup
process. =VLOOKUP(A2,Sheet1!A2:B3197,1,false)
thanks.