Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and replace
I have a table with 6 columns, A to F. Column A contains unique item numbers. Column B contains descriptions of those items. Columns C-F contain a random listing of the numbers from column A. I want to replace the random listings of items in C-F with the descriptions of the items from column B. There are 1300 items. Can I do this without running 1300 Find and Replaces? I would be happy with four new columns added that have the descriptions for the random items in C-F in the same order (not exactly a replace). Thanks! Al -- ovid962 ------------------------------------------------------------------------ ovid962's Profile: http://www.excelforum.com/member.php...o&userid=35452 View this thread: http://www.excelforum.com/showthread...hreadid=552302 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and replace
Assuming that you have 100 different items (number in A and description in B) A1:B100 use a vlookup in G1 =VLOOKUP(C1,$A$1:$B$100,2) and just drag and fill to the same area size as C1:F?? -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=552302 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and replace
Then you can just copy the G1:J? range, and paste special (Values) over C:F -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=552302 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and replace
Answered in .misc newsgroup...........
Vaya con Dios, Chuck, CABGx3 "ovid962" wrote: I have a table with 6 columns, A to F. Column A contains unique item numbers. Column B contains descriptions of those items. Columns C-F contain a random listing of the numbers from column A. I want to replace the random listings of items in C-F with the descriptions of the items from column B. There are 1300 items. Can I do this without running 1300 Find and Replaces? I would be happy with four new columns added that have the descriptions for the random items in C-F in the same order (not exactly a replace). Thanks! Al -- ovid962 ------------------------------------------------------------------------ ovid962's Profile: http://www.excelforum.com/member.php...o&userid=35452 View this thread: http://www.excelforum.com/showthread...hreadid=552302 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and replace
=VLOOKUP(C1,$A$1:$B$1300,2,FALSE)
See if this formula helps. you could put this in G1 and then copy it down and across. It should look at what is in C1 (which should be one of your random number codes), then it will look at all of A1 to B1300 and find the number code match and display the 2nd column over (which is the description). Test it out and see if it works for you. "ovid962" wrote: I have a table with 6 columns, A to F. Column A contains unique item numbers. Column B contains descriptions of those items. Columns C-F contain a random listing of the numbers from column A. I want to replace the random listings of items in C-F with the descriptions of the items from column B. There are 1300 items. Can I do this without running 1300 Find and Replaces? I would be happy with four new columns added that have the descriptions for the random items in C-F in the same order (not exactly a replace). Thanks! Al -- ovid962 ------------------------------------------------------------------------ ovid962's Profile: http://www.excelforum.com/member.php...o&userid=35452 View this thread: http://www.excelforum.com/showthread...hreadid=552302 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Find & Replace in VB macro | Excel Discussion (Misc queries) | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
VB Find and Replace | Excel Worksheet Functions |