lOOKUP FUNCTION

[MARKEGANDERSON]

hELLO ALL-

i am trying use this function:=LOOKUP(C4,Sheet2!$A$2:$A$1285,Sheet2!$L$2:$L$1285)

But my problem is if it does not get a match it still returns a value-

What can i use if it matches "C4" it returns the corresponding valaue in column L?

 

[VoG]

Try

=VLOOKUP(C4,Sheet2!$A$2:$L$1285,12,FALSE)

 

[doofusboy]

You could try:

=LOOKUP(C4,Sheet2!$A$2:$A$1285,11,FALSE)

 

[MARKEGANDERSON]

I tried the below formulas, but it gives me a #N/A error message, even when there is a MAtch

=VLOOKUP(C4,Sheet2!$A$2:$L$1285,12,FALSE)





For this formula-

=LOOKUP(C4,Sheet2!$A$2:$A$1285,11,FALSE)

I get an error message"too many arguments entered for this function"

 

[T. Valko]

I tried the below formulas, but it gives me a #N/A error message, even when there is a MAtch

=VLOOKUP(C4,Sheet2!$A$2:$L$1285,12,FALSE)





For this formula-

=LOOKUP(C4,Sheet2!$A$2:$A$1285,11,FALSE)

I get an error message"too many arguments entered for this function"

The "LOOKUP" should be VLOOKUP.

See this...

http://contextures.com/xlFunctions02.html#Trouble

 

[Aladin Akyurek]

hELLO ALL-

i am trying use this function:=LOOKUP(C4,Sheet2!$A$2:$A$1285,Sheet2!$L$2:$L$1285)

But my problem is if it does not get a match it still returns a value-

What can i use if it matches "C4" it returns the corresponding valaue in column L?

LOOKUP requires that the match vector is in ascending order. If the match
vector is in ascending order and consists of text, the formula needs a somewhat specific set up, somthing like:

=IF(LOOKUP(C4,Sheet2!$A$2:$A$1285)=C4,
    LOOKUP(C4,Sheet2!$A$2:$A$1285,Sheet2!$L$2:$L$1285),
    "Not Found")

This is equivalent in behavior to but faster than e.g.

=INDEX(Sheet2!$L$2:$L$1285,MATCH(C4,Sheet2!$A$2:$A$1285,0))