Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
wdjsxj
 
Posts: n/a
Default 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
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
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 02:36 AM
Instead of a negative number, I'd like to show zero... Dr. Darrell Excel Worksheet Functions 6 December 7th 05 09:21 PM
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
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 09:27 PM.

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"