Is there a formula that will work for this?

Question

I'm trying to pull a start date from a sheet into the sheet summary if the bucket is a certain bucket:

I've tried the below formulas but keep getting #UNPARSABLE:

=IF(CONTAINS("1.2 WON", Bucket:Bucket), COLLECT(Start:Start, @row))

=IF(bucket;"8.1 CURRENT DUE DATE",(VLOOKUP(xx/yy/zzzz,start:start, 8))

The bucket doesn't rest on the same row for every sheet, thus the need for a formula that will search one column and return the data from the same row in a different column.

Jeff Reisman · Accepted Answer

Try this:

=INDEX(Start:Start, MATCH("1.2 WON", Bucket:Bucket, 0))

Keep in mind, this will not work correctly if there are any errors in the Start column!