Conditional Formula with Vlookup

Copper Contributor

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?


1 Reply


=IF(A1="X", A9, IFERROR(VLOOKUP(M10, FileFormat, 2, FALSE), ""))