|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
May 6th, 2002, 06:34 AM
|
#1 |
|
New Member
Join Date: May 2002
Posts: 3
|
The formula Lookup keeps returning the cell value in the row above the one that I want.
Does anyone know how to fix it? Regards |
|
|
|
May 6th, 2002, 06:49 AM
|
#2 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,317
|
Quote:
|
|
|
|
|
|
May 6th, 2002, 06:51 AM
|
#3 |
|
Board Regular
Join Date: Feb 2002
Location: Calgary, Alberta Canada
Posts: 2,065
|
Could you show your formula? For an exact match, include the fourth parameter "false" or "0". VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) If you do not require an exact match (the fourth parameter is "true"), ensure that the table_array is sorted. |
|
|
|
|
May 6th, 2002, 06:59 AM
|
#4 |
|
New Member
Join Date: May 2002
Posts: 3
|
This is what I'm trying to do.
I have a list extracted from a database contaning username and logonscrip for 5 different domains (file A). I also have a list for every usernamn in a single domain(file B). I need a function to match the username from file B with the properties from file A. Ex from file A Testuser:T-domain:logon.bat The fomula is =LOOKUP(A3;'User&logon'!A:A) Can you help me? Regards [ This Message was edited by: RisingPhoenix on 2002-05-06 06:02 ] |
|
|
|
|
May 6th, 2002, 07:33 AM
|
#5 |
|
Board Regular
Join Date: Feb 2002
Location: Calgary, Alberta Canada
Posts: 2,065
|
With Lookup, the information must be sorted. complete the syntax for Lookup. Did you specify what column of information to return? With Vlookup, you can specify the column etc. try the complete syntax for Vlookup. See above and Help. - specify column to lookup - specify if you want an exact match "False" - specify actual range of information Please advise if lets the formula give correct answers. [ This Message was edited by: Dave Patton on 2002-05-06 06:38 ] |
|
|
|
|
May 6th, 2002, 08:36 AM
|
#6 |
|
New Member
Join Date: May 2002
Posts: 3
|
Thank U for your help. I still can't seem to get the correct data back, only the row above the one that I want.
Regards, |
|
|
|
|
May 6th, 2002, 09:11 AM
|
#7 |
|
Board Regular
Join Date: Apr 2002
Location: Greenwood, SC
Posts: 677
|
The range lookup seaches must be sorted (ascending). If the lookup function does not find the value to be looked up, it will return the value just before it.
It sounds to me like the value you are looking for and the value in your lookup range might be just a bit different (maybe a trailing space?). Whenever I do lookups, I like to nest them: =IF(LOOKUP(C4,F4:F14,F4:F14)=C4,LOOKUP(C4,F4:F15,G4:G14),"Not Found") Where C4 is the value to search for, F4:F14 is the search range and G4:G14 is the return range. Hope this helps, K |
|
|
|
|
May 6th, 2002, 10:20 AM
|
#8 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,317
|
Quote:
|
|
|
|
|
|
May 12th, 2011, 01:00 PM
|
#9 |
|
New Member
Join Date: May 2011
Posts: 2
|
Re: Formula Lookup returns wrong value
I too am experiencing the vlookup table returning the row above. Hmmm...
|
|
|
|
|
May 12th, 2011, 01:03 PM
|
#10 |
|
MrExcel MVP
Join Date: Oct 2006
Location: Bryan, TX
Posts: 21,127
|
Re: Formula Lookup returns wrong value
Welcome to the board...
Post your formula Post an example set of data (including lookupvalue and the array to look in). Post your expected results based on the example set of data.
__________________
Want better/faster responses to your questions? Use Excel Jeanie to post samples of your sheet. The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious. Life moves pretty fast. If you don't stop and look around once in a while, you could miss it. Ferris Bueller A.K.A. John Hughes, 1986 |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
