Formula Help: Cross-Sheet lookup to validate & input information

Steve Bertram

HI,

trying to have a cell in one sheet look at another sheet for its information. I need to check the value in a cell and if it equals 1 then copy the information from a different cell in the same row (in this instance column 1 in the range 'Design Phase Data Range 3'. However I keep getting the 'unparseable' error and can't see why. Grateful for any pointers.

=IF(VLOOKUP({Design Phase Data Dsgn Prnt}@row =1, {Design Phase Data Range 3}, 1,false))

Thanks

Steve

Paul Newcome

Are you able to provide a screenshot of each sheet with sensitive/confidential data removed, blocked, and/or replaced with "dummy data" as needed?

Steve Bertram

HI Paul,

This is the sheet I'm trying to get info from. I want to check the value is 1 in the column labelled Design Parent and if so copy the data from the column before 'Phase' This would be copied into a new blank sheet with the information going into the primary column

Thanks

Steve

Paul Newcome

Is there only going to be one row containing LIS-POR in the Primary Column and 1 an the Design Parent Column?

Steve Bertram

yes, as you will see from the POR-BIL example this is a 'parent' row with 'child' rows that have a value of 0 in the design parent column. I need to look up and copy all the parent rows.

Paul Newcome

Ok. And are you able to provide a screenshot showing column names of the target sheet?

Steve Bertram

Currently there are no Column names in the target sheet, but this info will go into what is the Primary Column. The other cells associated on a row will be populated by simple cell linking.

Paul Newcome

Try something along the lines of...

=INDEX(COLLECT({Other Sheet Column To Pull}, {Other Sheet Primary Column}, "LIS-POR", {Other Sheet Design Parent Column}, 1), 1)

Steve Bertram

Hi Paul,

Thanks for your assistance. I couldn't get this to do what I wanted to do (probably not explaining very well what it is i'm trying to achieve).

Anyway I have found another way, that fits at this point, to get where I need to be.

Once again your help is appreciated.

Kind Regards

Steve

Paul Newcome

Could you post your solution and then mark it as "helpful"? This will help others that are struggling with a similar problem to possibly find a solution.

Steve Bertram

Unfortunately the solution at this point is a manual one and simply uses cell linking to copy the information from one sheet to another. However, I will continue to investigate (during spare moments) and if I resolve it I will add to this discussion.