Forum Discussion
PedroPascualQuark
May 11, 2023Copper Contributor
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,FileFormat,2,FALSE),"")
may someone help me with this?
Regards
=IF(A1="X", A9, IFERROR(VLOOKUP(M10, FileFormat, 2, FALSE), ""))