Hi everyone,
Stuck on creating a formula in excel.
Column x,y and z are next to each other. I need a formula that functions like this:
if column x equals "a", and if column y equals "b" then pull/show what's in column z
I tried using If functions but I can't seem to get them to apply to entire columns.
Please help.
Stuck on creating a formula in excel.
Column x,y and z are next to each other. I need a formula that functions like this:
if column x equals "a", and if column y equals "b" then pull/show what's in column z
I tried using If functions but I can't seem to get them to apply to entire columns.
Please help.