Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
Count number of values in a cell | Excel Worksheet Functions | |||
How to return a dollar value for a part number entered in a cell | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |