Ok guys, here is what the problem is.
I have a column "reference number", now I want to make a column for "email" and depending what value is in the ref. No cell, the email will change accordingly, here is an example.
If the reference number is "THVP" then I want the email cell on the same row to be firstname.lastname@example.org and if the reference number is "SHVP" then I want the email cell on the same row to be email@example.com can anybody help me out here? Please?
Any help would be tremendously appreciated.