The syntax you have is wrong. You have "" within the MATCH().
Try: =IFERROR(INDEX(Categorisation!E:E,MATCH(Data!Z18,Categorisation!F:F,0)),"")
The syntax you have is wrong. You have "" within the MATCH().
Try: =IFERROR(INDEX(Categorisation!E:E,MATCH(Data!Z18,Categorisation!F:F,0)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks