Hi Folks,
Apologies for asking,
I have this array formula which works fine as long it's having data, but if there is no data will return N/A
=INDEX(LiveData!G:G,MATCH(1,(Sheet1!K6=LiveData!A:A)*(Sheet1!P6=LiveData!E:E),0))
Is any chance that I can make this show 0 or nothing if there is no match between two words?
Please let me know
Thank you.
Bookmarks