auto populate columns

[Navee138]

Hi I have the following spreadsheet attached, I am wondering, is it possible to populate the Team column (column B) based on the Employee name (column A), if so, what is the best way of doing this?

[AliGW]

Yes, as long as you have a lookup table somewhere - there isn't one in the workbook attached. INDEX MATCH or VLOOKUP will do it. If you need further help, please supply a sample workbook containing the lookup data.

[Sam Capricci]

Probably a small table some place with the employees in one column and the teams in the column beside them, then a vlookup, something like =VLOOKUP(A2,$I$2:$J$10,2,FALSE) to return the values - assumes the lookup table is in cells I2 through J10, adjust as needed.

[Navee138]

Hi instead of there being a lookup table and using the v-lookup formula, is there a way to do it with just the current data that is available, reason why I don't want to use formulas is due to the size of the spreadsheet. What I have attached in this thread is just a sample sized spreadsheet. Could Tables be used?

[AliGW]

What is the size of the spreadsheet it needs to work with (number of columns by number of rows)?

No, you can't do what you want, at least not without VBA: a column's cells can contain either data or a formula, but not both.

[AliGW]

I have moved this thread to the VBA section. You might also wish to update the thread title with a bit more detail.

[Navee138]

Hi can you provide link of this thread? I cannot seem to find it in the VBA section

[AliGW]

You are in it. As I explained (in both threads concerned), the thread has been moved: that means that it has moved, lock, stock and barrel. If you are reading this, you have found it.

[Navee138]

Hi, just thought I would try and give a bit more detail into what I am trying to achieve. If in cell A14 I enter 'RJ', I would like cell B14 to automatically populate to whatever has been entered in the rows above where the column A contains 'RJ'. For example, if 'Solution Delivery' is in column B for 'RJ', then when RJ is entered again, 'Solution Delivery' is automatically populated in column B.