would:

=IF(ISERROR(INDEX(EMP2009,MATCH($N$1,BuildingNo,0) )),"",INDEX
(EMP2009,MATCH($N$1,BuildingNo,0)))

help?


On 3 Lis, 12:04, Diddy wrote:
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