Pulling data from another sheet (vlookup?)

Hi @Paul Newcome

I'm getting #INVLAID COLUMN VALUE with formula =INDEX({4. SA Review Range 1}, MATCH([Safety Report ID #]@row, {4. SA Review Range 2}, 0))

@Paul Newcome It worked...I think. I'm going to go and try other columns I have that will be using the same formula, and I'll let you know. thank you SO much for your help!!

Hi hoping for some help please -

trying to create a sheet that will pull in "company" ( has the company name and address in column) 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 currently 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