Automatically populate columns in Excel based on another column information

[Laurrie Crosbie]

I need to put in a formula that will automatically populate B and C based on the number in A, i.e. everytime I type in the employee number listed, B and C will automatically populate with Joe Black and 2018-10-04
A B C
1 EMPLOYEE NUMBER NAME HIRE DATE
2 12345678989 Joe Black 2018-10-04

[¯\_(ツ)_/¯]

This can usually be done with lookup formulas (e.g. VLOOKUP or INDEX/MATCH), but you'll have to provide more details as to your data layout and values to get an exact formula.

[Laurrie Crosbie]

I was thinking of LOOKUP just not sure how to do the formula or how to attach an Excel document to this thread if you can.
Column A is titled: HEALTH CARD #
Column B is titled: NAME
Column C is titled: DATE OF HOSPITAL VISIT
- Employer wants to be able to type in the HEALTH CARD # and have the NAME and DATE OF HOSPITAL VISIT to automatically populate. This will be a long list of health card #'s and names/dates and health card #'s will not be in numerical order - scattered numbers, i.e., next time the employer types in 12345678989, Column B and C will automatically populate and the same with the other Health Card #'s. I don't know if this can be done.

[¯\_(ツ)_/¯]

It can be done if you have a "lookup" table somewhere else. If you're trying to enter formulas into the same table accumulating the data, that won't work very well without VBA code. (You'd be over-writing formulas with static text a bunch, I'd imagine.) Look in Excel Help for the VLOOKUP function for how to use that function (or search Google/this forum.)

[Pete_UK]

If you want to be able to attach an Excel workbook (sanitise it first), this is how to do it:

Click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't use the Paperclip icon (attachments button), as it doesn't work on this forum.

Hope this helps.

Pete

[Laurrie Crosbie]

Thanks. This is helpful.

[Laurrie Crosbie]

I tried to attach an excel document but not sure it worked.

[Pete_UK]

In the attached file I have coloured cell I2 yellow to indicate that is where you should enter the employee number (for convenience I have set up a Data Validation drop-down on that cell, so that you don't have to type a multi-digit number). The name appears in cell J2 because of this formula:

=IFERROR(VLOOKUP(I2,A:C,2,0),"")

and the date of birth is generated by this formula in K2:

=IFERROR(VLOOKUP(I2,A:C,3,0),"")

Notice that the two formulae are very similar - the only difference is the third parameter of the VLOOKUP function which determines the column number (2 and 3) which is where the data will be returned from.

Just change the Employee number in I2 using the drop-down, and the other data will immediately change.

Hope this helps.

Pete