| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex lookup issue | Excel Discussion (Misc queries) | |||
| Lookup Issue due to formatting | Excel Worksheet Functions | |||
| Lookup Issue | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| LOOKUP Command Issue | Excel Worksheet Functions | |||
Linear Mode
