| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP text return text
Im using
=LOOKUP(B343,N343:N468,L343:L468) to lookup the text in B343 within N343:N468 and return the respective data in column L. No joy just N/A# So I tried =LOOKUP(TEXT(B343,""),N343:N468,L343:L468) Which gave the same pitifull result. How should I identify the text type as using my "" probably doesnt refer to anything. The value in row B is a combination of numbers and letters so I would think it is just identified as a normal text string? Any help would be much appreciated Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell reference instead of text from within lookup() functio | Excel Worksheet Functions | |||
| Using IF to return more than text | Excel Discussion (Misc queries) | |||
| lookup a text cell and return text | Excel Discussion (Misc queries) | |||
| Get different numbers to return text?? | Excel Worksheet Functions | |||
| Return text | Excel Worksheet Functions | |||
Threaded Mode
