Hi Lino,

You might need to write a macro. Here's a book link that might provide insight:

https://books.google.com/books?id=0GDcCgAAQBAJ&printsec=frontcover&dq=excel+macros&hl=en&sa=X&ved=0ahUKEwibxfPzrK_bAhWR1lMKHQ7UDSMQ6AEIUjAG#v=onepage&q=excel%20macros&f=false

Have a great day!

--Adrian

Hi Lino,

You might need to write a macro. Here's a book link that might provide insight:

https://books.google.com/books?id=0GDcCgAAQBAJ&printsec=frontcover&dq=excel+macros&hl=en&sa=X&ved=0ahUKEwibxfPzrK_bAhWR1lMKHQ7UDSMQ6AEIUjAG#v=onepage&q=excel%20macros&f=false

Have a great day!

--Adrian

1) Create the final list by adding a new column to the right

2) Insert in the top cell of the new column the formula:

vlookup(, TopLeft1Column:BottomRight1Column, 2, False)

Example: vlookup(A1, Sheet1!A1:B10, 2, False)

If you want to drag this formula to all rows make sure you use the '$'

vlookup(A1, Sheet1!A$1:B$10, 2, False)

Hope it helps!

Alvaro

"concatenate" might be useful?

Hello, thanks everyone for the suggestions! The vlookup(A1, Sheet1!A$1:B$10, 2, False) formula did it!! I have had to use concatenate a lot, but for this specific task I need to have reference a table, I think it is called the array table, but not positive.

For the next task I was hoping to ask about (This research job just keeps demanding more excel acrobatics!), I need to someone find a way to add up all the values for each corresponding group.

As an example this would be:

Population of people for U.S. Counties...

County A, CA - 195

County B, CA - 333

County C, CA - 43

County D, WY - 44

County E, WY - 456

County F, WY - 231

So I want to simply that into

California Counties - 571

Wyoming Counties - 731

I don't know what to call this function, would this also be vlookup?

Thank you! :)

Assuming you have

Counties -> column A

Acronym -> column B

number ->column C

You should use

=SUMIF(B$1:B$10; "CA"; C$1:C$10)

Good luck!

Alvaro

Thank you very much!