Lookup Issue
 

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.

Lookup Issue
 

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.

Lookup Issue
 

My bet is that you're looking for an exact match, but you didn't use False or 0
as the 4th argument in your =vlookup() formula.

If all those things are true, then maybe you want something like:

=vlookup(a1,sheet2!a:e,3,false)

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.

--

Dave Peterson