IF Statement with Nested VLookup Formula

[pattih]

I need help with a formula where if column F in the estimate report sheet contains "Hughes" then lookup B24 and return the result in Column 12 of the Estimate Report. Excel accepts the formula, but I am getting a #N/A error message.

=IF(EstimateReport!$F$3:$F$1852="HUGHES",VLOOKUP(EstimateReport!B24,EstimateReport!$A$3:$M$1852,12,0))

Thank you.

 

[Dryver14]

Try,

=IF(ISNUMBER(MATCH("HUGHES",EstimateReport!$F$3:$F$1852,0)),VLOOKUP(EstimateReport!B24,EstimateReport!$A$3:$M$1852,12,0,"FALSE"))

 

[pattih]

Thank you for helping me with this formula.

I get an error message that says I have entered too few arguments for this function and then in the cell "FALSE" is highlighted. If I take "FALSE" out of the formula, I get the #N/A error again.

 

[Dryver14]

Sorry, I was no where near a spreadsheet when I did it.

You will get a circular reference anyway

=IF(ISNUMBER(MATCH("HUGHES",EstimateReport!$F$3:$F$1852,0)),VLOOKUP(EstimateReport!B24,EstimateReport!$A$3:$M$1852,12,0),"FALSE")