#NA issues.

[Hatter]

I have the following formulas in which I need blanks which works but having issues with #NA and cannot find the correct formulas - =IF(VLOOKUP(A10,'Film Stock Report (2)'!A:Y,25,0)=0,"",VLOOKUP(A10,'Film Stock Report (2)'!A:Y,25,0)) & =IF(VLOOKUP(A6,'Film Stock Report (2)'!A:Z,26,0)='Film Stock Report (2)'!$Z$3,$Z$3,'Film Stock Report (2)'!Z6)

 

[hagia_sofia]

Hello, wrap your formulas e.g. into IFNA function.

 

[RoryA]

If the first VLOOKUP fails, do you still want to perform the second one? Also, what if the second fails and the first one doesn't?

 

[Alex Blakenburg]

I am also unclear as to whether they are 2 separate formulas or not and the 2nd one doesn't really seem to make sense (at a mininum shouldn't the 2nd $Z$3 not also refer to the other sheet).
For your first formula how about something like this:

=LET(getVal ,XLOOKUP(A10, 'Film Stock Report (2)'!A:A, 'Film Stock Report (2)'!Y:Y, ""),
     IF(getVal="", "", getVal))

 

[Hatter]

Hello, wrap your formulas e.g. into IFNA function.

Hi, I've used ISNA in the past but cant seem to get it correct with these.