Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#Ref! Returned
John
I don't see any obvous problem with your formula. To troubleshoot those kinds of problems in messy formulas they can be calculated in parts. A lot of people don't know this, but you can highlight on the formula bar, only one of your nested functions or a rangename, then hit F9 and it will calculate only the highlighted part of your formula. For example, higlight match(d9,employeenames, 0), then hit F9 and see if you get a result or an error. Use that method to systematically rule out each part of your formula. Once you find out which embedded function is causing the error the problem will be obvious to you, maybe. Good luck. Ken Norfolk, Va |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
same name being returned | Excel Discussion (Misc queries) | |||
#N/A value is returned | Excel Worksheet Functions | |||
#value returned instead of data | Excel Worksheet Functions | |||
Using the returned value of a function | New Users to Excel | |||
#Value! Returned ? | Excel Worksheet Functions |