Formula help

[londa_vba]

Could some help me clean up the formula below?
I am trying to write out if B14 has no result then return no result, if B14 has a result then lookup A14 (name) and 7500 Data C20 (description) within the array 7500 Data A10:G500 and give the result listing in column 5 of array table without producing an error if the information is not found.

=IF(B14="","",IFERROR(VLOOKUPA14&'7500 Data'!C20,'7500 Data'!A10:G500,5),"")

I am getting a too many arguments error.

 

[awoohaw]

try: (you're missing a parenthesis after VLOOKUP, and one at the end.)

=IF(B14="","",IFERROR(VLOOKUP(A14&'7500 Data'!C20,'7500 Data'!A10:G500,5),""))

 

[londa_vba]

try: (you're missing a parenthesis after VLOOKUP, and one at the end.)

=IF(B14="","",IFERROR(VLOOKUP(A14&'7500 Data'!C20,'7500 Data'!A10:G500,5),""))

wonderful. thank you

 

[awoohaw]

I'm pleased you found a solution!

Best Wishes!