Forum Discussion
2 lists, 1 if
Hi everyone.
I'm trying to create such an IF command, that if a certain cell is empty, nothing happens, if it has lets say "1" a certain list prepaired earlier appears, if "2" a different list...
Hi Bartosz,
Formula shall work correctly if only your A1 cell is not formatted as text. If it's in text format when you receive blank if A1 is empty and "PKlim1" for any other value.
Check in any cell =ISTEXT(A1)
Ok. It's not tekst. It seems I've done something wrong in the whole thing. I think is the lists I've created. Could you walk me going through not creating a list but adding it to a specifik sheet.