| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup problem is killin me.
i have a data base on sheet 1, formula is on sheet 2. its sorted ascending
everything looks right, but it returns the value from the correct column but always picks from the previous row. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup problem is killin me.
Are you using all 4 arguments of the function?
Is the 4th argument 0 or "False", denoting that an exact match is called for? If "yes" to the above, post the formula you're using. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "seeinred04" wrote in message ... i have a data base on sheet 1, formula is on sheet 2. its sorted ascending everything looks right, but it returns the value from the correct column but always picks from the previous row. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup problem is killin me.
=VLOOKUP(G2,Sheet1!A1:F19677,5,TRUE)
=VLOOKUP(G2,Sheet1!A1:F19677,5) i've tried both and they both return value of the cell above the correct one. "RagDyer" wrote: Are you using all 4 arguments of the function? Is the 4th argument 0 or "False", denoting that an exact match is called for? If "yes" to the above, post the formula you're using. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "seeinred04" wrote in message ... i have a data base on sheet 1, formula is on sheet 2. its sorted ascending everything looks right, but it returns the value from the correct column but always picks from the previous row. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup problem is killin me.
If you're looking for an exact match
=VLOOKUP(G2,Sheet1!A1:F19677,5,0) no sorting required "seeinred04" wrote: =VLOOKUP(G2,Sheet1!A1:F19677,5,TRUE) =VLOOKUP(G2,Sheet1!A1:F19677,5) i've tried both and they both return value of the cell above the correct one. "RagDyer" wrote: Are you using all 4 arguments of the function? Is the 4th argument 0 or "False", denoting that an exact match is called for? If "yes" to the above, post the formula you're using. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "seeinred04" wrote in message ... i have a data base on sheet 1, formula is on sheet 2. its sorted ascending everything looks right, but it returns the value from the correct column but always picks from the previous row. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup problem is killin me.
same thing. I'm sorry, but ..... don't know what else to do.
"daddylonglegs" wrote: If you're looking for an exact match =VLOOKUP(G2,Sheet1!A1:F19677,5,0) no sorting required "seeinred04" wrote: =VLOOKUP(G2,Sheet1!A1:F19677,5,TRUE) =VLOOKUP(G2,Sheet1!A1:F19677,5) i've tried both and they both return value of the cell above the correct one. "RagDyer" wrote: Are you using all 4 arguments of the function? Is the 4th argument 0 or "False", denoting that an exact match is called for? If "yes" to the above, post the formula you're using. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "seeinred04" wrote in message ... i have a data base on sheet 1, formula is on sheet 2. its sorted ascending everything looks right, but it returns the value from the correct column but always picks from the previous row. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup problem is killin me.
It sounds like you have a data problem.
Are your values imported, returns from other formulas, or keyed in? BTW ... What happens with this formula: =Index(Sheet1!E1:E19677,Match(G2,Sheet1!A1:A19677, 0)) ? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "seeinred04" wrote in message ... same thing. I'm sorry, but ..... don't know what else to do. "daddylonglegs" wrote: If you're looking for an exact match =VLOOKUP(G2,Sheet1!A1:F19677,5,0) no sorting required "seeinred04" wrote: =VLOOKUP(G2,Sheet1!A1:F19677,5,TRUE) =VLOOKUP(G2,Sheet1!A1:F19677,5) i've tried both and they both return value of the cell above the correct one. "RagDyer" wrote: Are you using all 4 arguments of the function? Is the 4th argument 0 or "False", denoting that an exact match is called for? If "yes" to the above, post the formula you're using. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "seeinred04" wrote in message ... i have a data base on sheet 1, formula is on sheet 2. its sorted ascending everything looks right, but it returns the value from the correct column but always picks from the previous row. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup problem | Excel Discussion (Misc queries) | |||
| Vlookup problem with Date Time | Excel Worksheet Functions | |||
| vlookup Problem | Excel Discussion (Misc queries) | |||
| VLOOKUP Problem | Excel Worksheet Functions | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Hybrid Mode
