I'm using this formula, but I'm getting "Vlookup couldn't find requested value"
Right now I don't have any data in the tables yet, which is why there is an error. I'd rather it just appear blank. IFERROR(any-expression,if-error) But I'm not positive on the "Any-Expression"
IF(VLOOKUP(MAX($Z$3:$Z$18),$Z$3:$AA$18,2,0)="F",TRUE,FALSE)
iPhone 6s Plus, iOS 10.0.1
Is your intent to return TRUE if the largest numerical value in column Z is on the same row as "F" in column AA and return FALSE if the largest numerical value in column Z is not in the same row as "F" in column AA? And show a blank if there is no numerical value in column Z?
If so then something like this will work:
=IFERROR(IF(VLOOKUP(MAX(Z),Z:AA,2,0)="F",TRUE,FALSE),"")
Note that in Numbers it can be a little awkward to have "Excel-style" tables that wide. Unlike in Excel, it is easy in Numbers to work with multiple smaller tables on the same sheet. Also it is usually much easier and cleaner to refer an entire column (as in my example) rather than a range within a column. If you haven't already, recommend checking out the templates at File > New in your menu for examples of efficient document design in Numbers.
SG
whatever formula you presently have in the cell showing the error, select all, then cut (using the menu item "Edit > Cut")
now use the formula
=iferror(<FORMULA>, "")
replace <FORMULA> with the formula you but, by placing the cursor , paste
Adding IFERROR to formula
