| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with an Index Match Array
I have the following formula:
{=INDEX(nursetb!$D$1:$D$1354,MATCH(1,(ytd!C$2=nurs etb!$A$1:$A$1354)*(ytd! $A6=nursetb!$B$1:$B$1354),0))} Which works great, but if there is no information to match etc it returns a #n/a any chance I can get this to return a blank somehow. Many thanks in advance Petes girl -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning an array from the INDEX function | Excel Worksheet Functions | |||
| Trying to MATCH a value out of a cell on an ARRAY - help pls | Excel Worksheet Functions | |||
| Returning MULTIPLE values with Index and Match | Excel Discussion (Misc queries) | |||
| Help please - Index and Match "like" values | Excel Worksheet Functions | |||
| Index and Match issues | Excel Worksheet Functions | |||
Threaded Mode
