| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add if blank statement to index match
Hi everyone,
I'm using the following formula to get data from a table =INDEX(EMP2009,MATCH($N$1,BuildingNo,0)) If there is no data matching the building number and employee data in the appropriate row of EMP2009, then I'd like the formula to return a blank. I'm getting all tied up trying to add an if statement and it would be fantastic if anyone could help. Cheers Diddy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| index, Match statement | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| Sum within an Index Match Statement | Excel Discussion (Misc queries) | |||
| index match with blank entries | Excel Worksheet Functions | |||
Threaded Mode
