May 11 2023 06:44 AM
Hi Community,
i am struggling to find the correct formula, i would nee to create:
formula in Cell A10 : if cell A1 is equal to "X" then give value of cell A09 , if not then (VLOOKUP(M10,FileFormat,2,FALSE),"")
may someone help me with this?
Regards
May 11 2023 06:59 AM
=IF(A1="X", A9, IFERROR(VLOOKUP(M10, FileFormat, 2, FALSE), ""))