Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
djDaemon
 
Posts: n/a
Default VLOOKUP based on PART of another cell's text

I want to automatically fill in column B (from a seperate list) based on part
of the cell in column A.

For instance,
A312 = "MW3-11315AH"

Now, I would like to fill in B312 with "SHANK", based on the "MW3" at the
beginning of the text string in A312.

Also,
A313 = "B2-P-N49B-A0014"

I would like to fill in B313 with "ARM ASSY", based on the "A0014" at the
end of the text string in A313. However, the numerical portion of "A0014"
(A####) will change.

I was hoping to create a list on another worksheet, and use VLOOKUP, but I
am unsure as to the implementation of wild-card or partial-content lookups.

Any help is GREATLY appreciated!
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
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM
Linked cells and text boxes Alexlondon11 Excel Discussion (Misc queries) 2 November 23rd 05 05:10 PM
linking text cells Pilgrim One Excel Worksheet Functions 1 October 19th 05 12:36 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
conditional formating - Highlighting text cells based on sales res ANDREW_B Excel Discussion (Misc queries) 7 December 2nd 04 05:27 PM


All times are GMT +1. The time now is 06:52 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"