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

Joe4 · Mar 30th, 2004, 04:46 PM

WELCOME TO THE BOARD!

Check out the VLOOKUP function in Excel help. Note that naming your range will make it easier to reference in the VLOOKUP formula.

Whisperer14 · Mar 30th, 2004, 04:56 PM

Ben
welcome to the board.

Put your numbers in one column and the names next to them in another column, assuming you have used columnA and B, then one of the formulae you could use is based on the Index function, array type.

Basically this looks at a range of cells and then returns the value in the specified row and column so a formula placed in E1 which reads

Code:

=Index($A$1:$B$3,D1,2)

will provide you with the information in the B column that matches the number that you have typed in D1 - if you type in 1 in D1 using your example then E1 will contain Ben
HTH

Ben_Holmes · Mar 30th, 2004, 08:34 PM

Thanks Mate that works a treat.

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

Mar 30th, 2004, 04:46 PM	#2
Joe4 MrExcel MVP Moderator Join Date: Aug 2002 Posts: 14,220	Re: Value = specific meaning?? Help WELCOME TO THE BOARD! Check out the VLOOKUP function in Excel help. Note that naming your range will make it easier to reference in the VLOOKUP formula. __________________ TIPS FOR FINDING EXCEL SOLUTIONS 1. Use the built-in Help that comes with Excel/Access 2. Use the Search functionality on this board 3. A lot of VBA code can be acquired by using the Macro Recorder.

Mar 30th, 2004, 04:56 PM	#3
Whisperer14 Join Date: Nov 2002 Location: Cornwall UK Posts: 589	Ben welcome to the board. Put your numbers in one column and the names next to them in another column, assuming you have used columnA and B, then one of the formulae you could use is based on the Index function, array type. Basically this looks at a range of cells and then returns the value in the specified row and column so a formula placed in E1 which reads Code: =Index($A$1:$B$3,D1,2) will provide you with the information in the B column that matches the number that you have typed in D1 - if you type in 1 in D1 using your example then E1 will contain Ben HTH __________________ Never too old to learn...

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

Mar 30th, 2004, 08:34 PM	#4
Ben_Holmes Join Date: Mar 2004 Posts: 117	Thanks Mate that works a treat. Kind Regards Ben