Menu

Linking a Specific Word to a Specific Number

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.worksheet.functions

Bondi

Bondi is offline

external usenet poster

Posts: 94

Default

Linking a Specific Word to a Specific Number

wrote:
Hell all,

I have a workbook which contains several worksheets. Each worksheet
contains specific data as text with an ID number. i.e. Hip ID number
is 2. The word Hip and its ID number are located in the Body Part
worksheet. There's a main worksheet named Map, which is where I would
like to be able to type the word Hip and have the ID number
automatically appear in a specific cell in the Map worksheet.

This is the Body Part worksheet

Body Part ID Body Part
1 Shoulder
2 Hip
3 Knee

This is the map:

Category ID Body Part Complaint Element Group Question
2 (cell b6) Hip (cell I6)

I would like to type the word Hip under body part on cell I6 and have
the number 2 appear automatically in the Category ID cell b6.

Thanks in advance

Hi,

Maybe you can use some variation of Index() and Match() along the lines
of:

=INDEX('Body Parts'!A2:B4,MATCH(I6,'Body Parts'!B2:B4),1)

If your list is in range A2:B4

Regards,
Bondi

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Pasting charts to Word from Excel as picture	Hari	Charts and Charting in Excel	5	July 5th 06 08:04 PM
count the number of times a specific word appears in a column	BAR	Excel Worksheet Functions	1	June 27th 06 05:03 PM
Pulling Data off Web - Need Function Help	patfergie44	Excel Worksheet Functions	9	June 22nd 06 03:27 AM
how do I find an average number of specific words in a column	cashgrfx	New Users to Excel	7	January 6th 05 04:44 PM
getting specific info from a word document into excel	smintey	Excel Discussion (Misc queries)	3	December 8th 04 08:20 PM

All times are GMT +1. The time now is 12:26 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement