Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning cell values to return a number
Hi,if you put the following in column a and column b,
A Cook 7.5 A Craig 8 B Innes 8 B Kirby 7.5 C Gouder 8 and you have the formula in cell c2: VLOOKUP(C1,A1:B5,2) then when you can input the text in c1,e.g. a cook ,the corresponding value will appear in cell c2,i.e.7.5 €œwhatzzup€ç¼–写: 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 | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
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 | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |