Excel Help - Please

Frabjous

Gorilla

13y

I don't know much about macros (in fact I've been looking for good materials to learn more about them in the last days), but what you are looking for can be easily done with the vlookup function. And given that you need to do it just monthly anyway, it shouldn't be a huge drag to repeat the process everytime.

If you don't know the function, here's a short tutorial: http://www.contextures.com/xlfunctions02.html

edit: damn ninjas

Authored by: Certified Consulting Professional - 1st Year AnalystCertified Consulting Pro

lunchis4wimps

Baboon

13y

wow you must be a pre-analyst or an intern's intern...

Chance favors only the prepared mind.

Prospect in VC

Anonymous

13y

Authored by: Certified Venture Capital Professional - 3rd+ Year AnalystCertified Venture Capital Pro

Frabjous

Gorilla

13y

Nobama88:
lunchis4wimps:
wow you must be a pre-analyst or an intern's intern...

Yeah yeah yeha, I'll live.

Ahahaha, nice one.

Authored by: Certified Consulting Professional - 1st Year AnalystCertified Consulting Pro

lunchis4wimps

Baboon

12y

Just kidding...if you do a Google search there are some pretty good sites I have found including forums that could explain v-lookup etc. better than I can. Might be worth it to download a copy of an Excel manual for reference, too.

Chance favors only the prepared mind.

Nabooru

King Kong

12y

Just make sure to copy paste values before you close the spreadsheet you're referencing from

Authored by: Certified Asset Management Professional - 3rd+ Year AnalystCertified Asset Management Pro

tylderdurden

Gorilla

12y

Best Response

You can use the following macro.

Sub replace_company_names()

find_numbers = Array("234", "567", "3")
Replace_companies = Array("First Company", "Second Company", "Third Company")

Columns("a:a").Select
Range("a:a").Activate

array_size = UBound(find_numbers)

For i = 0 To array_size

    Selection.Replace What:=find_numbers(i), Replacement:=Replace_companies(i), LookAt:=xlPart, _
    SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
    ReplaceFormat:=False

Next i

End Sub

Or you can use index(match)

Index + match is better than hlookup and vlookup imo because it's not column or row dependent. You can move in any dimension.

lkc

Senior Baboon

12y

Neque voluptatem eius eum consequatur officia dolore sunt eos. Perferendis id fugit ipsam libero veritatis. Tenetur est non fugit aut ratione nemo magni. Velit neque ut corporis recusandae laudantium doloribus est.

Quis hic qui accusamus accusantium quidem consequatur odit. Aliquam omnis consequatur doloremque aliquid ea officia. Sequi modi ea qui. Necessitatibus voluptatum fuga sint cupiditate eveniet rerum. Consequuntur expedita dolores nisi facilis et repellendus.

Laborum cupiditate asperiores alias non minima qui. Optio ut saepe quia et. Aliquid vitae placeat aliquam enim eaque sapiente earum. Saepe eius debitis qui. Rerum eos impedit enim eveniet et.