Value = specific meaning?? Help

Ben_Holmes · Mar 30th, 2004, 04:44 PM

Hi just found this great web site.

I am currentley getting to grips with excel but need some help.

I don't know how to do the following.

I want to input the following

1 = Ben
2 = Scott
3 = Dave etc

I then want on another sheet to input either 1 2 or 3 in to the spreadsheet and it to come up with the corresponding name.

I have attempted using IF function but cant seem to get it to do what I want.

Any help would be appreciated.

Kind Regards ben

Mar 30th, 2004, 04:44 PM	#1
Ben_Holmes Join Date: Mar 2004 Posts: 117	Value = specific meaning?? Help Hi just found this great web site. I am currentley getting to grips with excel but need some help. I don't know how to do the following. I want to input the following 1 = Ben 2 = Scott 3 = Dave etc I then want on another sheet to input either 1 2 or 3 in to the spreadsheet and it to come up with the corresponding name. I have attempted using IF function but cant seem to get it to do what I want. Any help would be appreciated. Kind Regards ben

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode