# isnumber search match error

1. ## isnumber search match error

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.

Many thanks and regards,

Neilesh

isnumber search match error.xlsx

2. ## Re: isnumber search match error

this portion returns true =ISNUMBER(SEARCH("2016",G2,1))
this part is returning #N/A =MATCH(YEAR(C4),C4,0)
what is it you are trying to have the match do?
Overall, what does your data look like that you are using that formula?

3. ## Re: isnumber search match error

is this closer to what you are trying to get to?
=IF(ISNUMBER(SEARCH("2016",G2))=YEAR(C4),ROUND(B4/E4,0),ROUND(B4*F4,0))

EDIT: maybe better yet...
=IF(--RIGHT(G2,4)=YEAR(C4),ROUND(B4/E4,0),ROUND(B4*F4,0))
at least for what you showed.

4. ## Re: isnumber search match error

Enter in G4 and drag formula across to H4
Formula:
`Please Login or Register  to view this content.`

5. ## Re: isnumber search match error

Thank Sambo Kid and Alkey, provided solution worked perfectly. I do appreciate your prompt and perfect solution. Thanks a ton.

6. ## Re: isnumber search match error

That's great, glad we could help AND thank you for the rep!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1