Trying to get a cell to auto populate info - based on the data on another spreadheet.

[pleb2019]

Hello!!

I have attached reference..

Basically in sheet 2 "customer orders" i want to be able to type the customer name - and the customer # will populate (referencing from sheet 1 - customer list).

Not sure where to starT?

Moderator note: Please review our rules regarding thread titles. As a courtesy I've changed the title for you this time.

[FlameRetired]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Since you are relatively new to the forum I went ahead and changed it for you this time.

[Pete_UK]

... Not sure where to start ...

Well, the first thing is to change your title - this should summarise what it is you are trying to achieve, and if you don't change it a Moderator or Admin will come along soon and block your thread until you do - see Forum Rule 01 from the menu at the top of the screen.

Then you could look at VLOOKUP and/or INDEX/MATCH functions in XL Help.

Pete

EDIT: Ah! Beat me to it, Dave.

[huuthang_bd]

You can use VLOOKUP function

Please Login or Register  to view this content.

[pleb2019]

Ok so i updated the title...
I dont know excel that well so whether or not it is specific enough, i am not sure...
I guess that's why im looking for help...

I'll check the Vlookup and or Index/Match function and see how i go

thanks

[FlameRetired]

@ pleb2019

Looks good.

[pleb2019]

Great got it working... thanks...

=INDEX('Accounts H2'!B2:B76,MATCH(C15,'Accounts H2'!A2:A76,0))

The only issue i have now is that i want it to match C15...
the next line C16..
the next line c17

But if i drag the formula down, it updates the fields for Index and Match... e.g.
instead of
=INDEX('Accounts H2'!B2:B76,MATCH(C14,'Accounts H2'!A2:A76,0))
it shows
=INDEX('Accounts H2'!B8:B82,MATCH(C20,'Accounts H2'!A8:A82,0))

[pleb2019]

Appreciate this might be really basic - but I have no idea.
Happy to learn myself if you can direct me

[huuthang_bd]

If you don't want the reference change when copy or fill, you have to use absolute reference.
When typing the formula, hit F4 after select a reference to change reference type (or put a dollar sign front of column letter and/or row index to change into absolute/mixed reference).
This is formula with absolute reference.

Please Login or Register  to view this content.

[pleb2019]

great thanks so much
the use of the $ before the row and column.

appreciate the help

[FlameRetired]

pleb2019,

You didn't ask, but please see if this article is helpful.

Relative and Absolute Cell References