Return First Match Value

[pezalmendra]

Hi,

I have the following code for lookup a value on a range and return back the result from another range.
The code runs okay the only thing is that is NOT returning the first match and I would like it to return the first value that has been found.

Please Login or Register  to view this content.

Thanks!

Kind regards

[martindwilson]

is the data in the lookup range sorted ascending?

[pezalmendra]

Yes, the range from column "E" is ascending.

Maybe is useful to know that there are hidden cells in the lookup range.

Regards

[martindwilson]

hiddent wont matter its whats in them that does, what is in the whole range of column e
do you get the same resulys with using the worksheet function directly in the work sheet?
=lookup("x",E17:e1000,ab17:ab1000)

[bulina2k]

hi pezalmendra!

have you tryied like this?

Please Login or Register  to view this content.

[pezalmendra]

That formula will return the second value from the range (as the code I posted). I am interested in the first value that match that condition...

[pezalmendra]

bulina2k your code works excellent!

Thank you very much!!

[martindwilson]

well glad thats fixed but lookup will work if range sorted correctly and no duplicates or it finds the last so that was your problem
=LOOKUP(2,{1,1,1,2,2,2,3,4,5,6},{1,2,3,4,5,6,7,8,9,10}) would return 6