Forum Discussion
Conditional Formula with Vlookup
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,FileForm...
=IF(A1="X", A9, IFERROR(VLOOKUP(M10, FileFormat, 2, FALSE), ""))