Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
whatzzup
 
Posts: n/a
Default Assigning cell values to return a number

Good Morning All
I am trying to create a formula or macro where i can assign an operative
name to a value such as
7.5 A Cook
8 A Craig
8 B Innes
7.5 B Kirby
8 C Gouder
Where i can type the name A Cook in a cell the value 7.5 appears instead and
same with A Craig.
Can i have a bit of help please??? Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
paul
 
Posts: n/a
Default Assigning cell values to return a number

vlookup will do what you want but not in the cell that you actually type the
name,you can type a name in say a1 and have your value show up somewhere else
asuming the table you have demonstrated is in cells a2 to b6.The names
however must be in the LH column and the numbers to the right
your formula typed in b1 is =vlookup(A1,A2:B6,2,false).When you type A Cook
in a1
7.5 will show up in B1.The spelling must be exact however or you will get
the N/A error
--
paul
remove nospam for email addy!



"whatzzup" wrote:

Good Morning All
I am trying to create a formula or macro where i can assign an operative
name to a value such as
7.5 A Cook
8 A Craig
8 B Innes
7.5 B Kirby
8 C Gouder
Where i can type the name A Cook in a cell the value 7.5 appears instead and
same with A Craig.
Can i have a bit of help please??? Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
return largest number of a list of numbers in the same cell Hells Excel Worksheet Functions 2 October 5th 05 01:52 PM
Count number of values in a cell nyc_doc Excel Worksheet Functions 3 July 31st 05 12:34 AM
How to return a dollar value for a part number entered in a cell free2bjmg Excel Worksheet Functions 3 July 24th 05 01:26 AM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 08:18 AM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 08:12 PM


All times are GMT +1. The time now is 01:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"