Hello I am looking for help with the following formula.
I have a IF formula using a VLOOKUP
=IF((VLOOKUP(A2,'[MySource.xlsx]Sheet1'!$B$2:$L$251,2,FALSE))=0,"",VLOOKUP(A2,'[MySource.xlsx]Sheet1'!$B$2:$L$251,2,FALSE))
This works great once my worksheets and workbooks are populated. My problem is creating a new worksheet for future use. When I enter the formula into a page with no data in column A, I get the #N/A error. This does not look very professional. I am trying to clean this up with an IFERROR but I end up getting a "Too many arguments" error.
My goal is to have the page appear Blank.
Bookmarks