Lookup Issue

[Pat]

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.

 

[Mike H]

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

 

[Dave Peterson]

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)