two similar match/search functions, only one works

[Blaise815]

Hello,

I have two functions:

Function A:
={MATCH($AD$51 & 1,('AMUSA PRICING'!$D$165:$D$1159) & (--NOT(NOT(SEARCH($AD$50,'AMUSA PRICING'!$L$165:$L$1159)))),0)+164}

Function B:
={MATCH($AD$51 & 1,('AMUSA PRICING'!$D$165:$D$1159) & (--NOT(NOT(SEARCH($AD$52,'AMUSA PRICING'!$M$165:$M$1159)))),0)+164}

Only Function B returns an answer; I get a #N/A for Function A.

I have tested out the following functions and they return answers with no errors:

={MATCH(1,(--NOT(NOT(SEARCH($AD$50,'AMUSA PRICING'!$L$165:$L$1159)))),0)+164}
={MATCH($AD$51,'AMUSA PRICING'!$D$165:$D$1159,0)+164}
={MATCH(1,(--NOT(NOT(SEARCH($AD$52,'AMUSA PRICING'!M165:M1159)))),0)+164}

Any thoughts as to what might be causing this issue?

What I am trying to do is combine a matching function with a searching function, which I seem to be able to do for Function B, but not Function A. The "D" column is for a horsepower value (always a whole number) so I can control entry via data validation. The "M" column contains data listing out different voltages with things like "208/460V" in a cell, so I want to be able to search "208" or "460" and return the same cell each time. Similarly, for the "L" column I have data that's a mixture of five different unique entries, but two entries contain similar terms and both should appear if the proper search term is entered (e.g. I search "V-Belt" and I get values from "V-belt" and "V-belt for special use"). I am able to edit everything, so if changing the way I am setting up my data columns is required instead of the formulas I can do that as well.

Ultimately I'd like to be able to take some input values for HP (Column D), Voltage (Column M), and Drive Type (Column L) and come up with the row that fits all the criteria using a formula.

[newdoverman]

The error that you are getting is one presented when the value isn't available. Are you sure that the value that you are looking for in the first formula is actually in the range being searched?
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data. (Remove private or sensitive data that shouldn't be published)

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Click on Browse under Upload Files from your Computer and then find the file on your computer using the dialogue that opens. Click on Open then click on Upload. Click on Close this Window. Click on Submit.