Home |
Search |
Today's Posts |
#4
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Service work order | Charts and Charting in Excel | |||
need check two worksheets to lookup a value | Excel Discussion (Misc queries) | |||
The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions | |||
Lookup with logic | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |