Formula Lookup returns wrong value

[RisingPhoenix]

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

 

[Aladin Akyurek]

On 2002-05-06 05:34, RisingPhoenix wrote:
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

Care to post the formula that you use along with what you want it to do?

 

[Dave Patton]

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.

 

[RisingPhoenix]

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

 

[Dave Patton]

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

 

[RisingPhoenix]

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,

 

[kkknie]

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

 

[Aladin Akyurek]

On 2002-05-06 05:59, RisingPhoenix wrote:
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

What value is in A3 which figures as lookup value in the formula you posted?

 

[StreetMan]

I too am experiencing the vlookup table returning the row above. Hmmm...

 

[Jonmo1]

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.