Pull Data: enter account number and auto-fill company name & address from a second sheet

System

This discussion was created from comments split from: Pulling data from another sheet (vlookup?).

Ashley Ryder

Hi hoping for some help please -

trying to create a sheet that will pull "company" ( has the company name and address in it) based on "Act No" Column from a sheet that i'm trying to set up

Test master sheet is currently called "Concept VRS" and new target sheet is curently called "AR Concept" both sheets have columns named "Company" & Act No"

What I would like to achieve is when I enter in AR concept an account number it fills the company column with the company name & Address from the Concept VRS sheet. I could then hopefully adapt and replicate for other columns to pull in basic data.

Have tried adapting from previous examples but unable to get any to work for me.

Any help greatly appreciated

Regards

Ashley

Paul Newcome

@Ashley Ryder You would need something along these lines (with cross sheet references set up as needed):

=INDEX({Source Sheet Company Name Column}, MATCH([Account Number Column name]@row, {Source Sheet Account Number Column}, 0))

Ashley Ryder

Many thanks for your help will give it a try later.

Regards

Ashley