Hello,
I want to create a function where if I enter a value (text) in a cell then another value is taken from a two column list and entered in a different cell e.g. I enter "John" in cell A1 and "A" is taken from a table and entered in cell C1. I think it could be a VLOOKUP or IF function but I can't seem to get it right. Hope I've explained this clearly, thanks for any help.
I want to create a function where if I enter a value (text) in a cell then another value is taken from a two column list and entered in a different cell e.g. I enter "John" in cell A1 and "A" is taken from a table and entered in cell C1. I think it could be a VLOOKUP or IF function but I can't seem to get it right. Hope I've explained this clearly, thanks for any help.