spalmarez Wrote:
I don't think I explained my description correctly.

This Lookup function works returns value 238348 (I am looking for
238355):
=LOOKUP(CONCATENATE("2",F2),A2:A100,C2:C100)

I would like to do this but it doesn't work. It returns the value in
row 254 (I am looking for 23855), My return value should be 238348 but
it isn't. Why would it work up to 100 or so rows and not more rows?:

=LOOKUP(CONCATENATE("2",F2),A2:A254,C2:C254)

That formula cannot return either 238348 or 238355 since what it
returns is necessarily a date because of C2:C254.

Having said that, What does F2 house?


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=276426