| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent help..nested functions..
Post the formula you're using.
-- Brevity is the soul of wit. "SID" wrote: Hi I am Siddharth, I have a 2 column database in Sheet2 of a workbook file. I have a 15 digit number say 550660506050504 I extracted 4 numbers from the above specified number say 6605. now problem is that I have to search this number from the database(Sheet2) which is definitely there. I have used vlookup, Hlookup which have generated the corrrect result, but only when i manually enter this number in a cell with out any formula in the cell. Problem statement is hlookup & vlookup is not producing a result when I am referencing this cell which has a formula MID to extract 4 numbers from the 15 digit number. i hope you understand my problem. Kindly help asap. Thanks & regards. -- Siddharth Sood |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there any way around the maximum of seven nested functions? | Excel Worksheet Functions | |||
| nested if functions in Excel 2002 | Excel Worksheet Functions | |||
| limit of 7 nested functions? | Excel Worksheet Functions | |||
| how do I use multiple nested functions? | Excel Worksheet Functions | |||
| ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS | Excel Worksheet Functions | |||
Threaded Mode
