Dear Experts,
Please find here attached sample workbook, where i tried isnumber search match formula in cell G4 and H4 but it is giving #N/A error.
In cell G2 there is description which contains year as well and from the Cell G2 description i was trying to search year and match with cell C4 Year and if it matches then the expected result would be as mentioned in Cell J4 or else the output would be of Cell K4.
Request to you please help me.
Many thanks and regards,
Neilesh
isnumber search match error.xlsx
Bookmarks