Lookup value on an array range and return value from another column when value is found

[vladi305]

I'm trying to make a formula that works to solve this like the index match but the match works only with one column to search the value so I'm getting errors

I want to for example lookup for value #3 on range from B1:F300
when that value is found return the reference value from column 1 which is the date or the first column on the table

 

[Fluff]

You're welcome & thanks for the feedback.