You should start by posting your lookup formula and some sample data

"Pat" wrote:

I'm having a problem using the lookup function among various sheets in my
workbook. It appears that the lookup is off by one row. Has anyone seen or
heard of this in the past? I'm happy to send the sheet to anyone interested,
I don't see how to attach.