Automatically fill in fields upon entering a customer ID

[cbrackley9]

Hi all,

First off, sorry if this is in the wrong place but I wasn't sure whether to class this as a Macro problem or a formula function and I'm sorry if this has been posted before but the search bar is such a struggle

So, my problem:

I was wondering how you would automatically fill in detail fields after verifying a customer number. For instance, I enter the customer ID and their name, address etc is entered automatically. I've tried creating a mock-up database using Access and linking it to Excel but it doesn't seem to want to play and I'm not sure of the formula/code to use either.

I've tried using =VLookup but that makes me stumble everytime so if someone could explain that, it would be much appreciated :P

I was also thinking about using a button and code in the function with VBA. Anyone give me a hand with that?

[djapigo]

Welcome cbarckley9,

I've attached a sample VLOOKUP... you simply enter in A2 a Cust ID and it returns their info...

Let me know what you think...

[FDibbins]

Hi cbarckley9 and welcome to the forum

Either vlookup() or index/match will give you what you need. vlookup is (possibly) the easier of the 2, but has the restriction that it cannot look to the left of the column that has the criteria you are looking for (ie, it cant look "behind" itself)

vlookup syntax is...
=VLOOKUP(what-you-want-to-find,range-to-search-in,column-that-contains-the-match,FALSE) FALSE is for finding an exact match

index/match/match syntax is....
=index(range,row,column)
you can replace row and/or column with match...
=match(criteria-to-search-for,column-containing-the-criteria,0)...this is for the row part 0 is for an exact match
=match(criteria-to-search-for,row-containing-the-criteria,0)...this is for the column part

let me know how you make out please?

[cbrackley9]

Thanks for the reply guys, I'll try both suggestions and let you know the results

[cbrackley9]

Welcome cbarckley9,

I've attached a sample VLOOKUP... you simply enter in A2 a Cust ID and it returns their info...

Let me know what you think...

I've tried this out and followed the little dandy notes you left (Thanks for those :D) and managed to re-create a similar thing. Problem solved!

Thanks a lot for the help