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

 

[vladi305]

I'm posting a screenshot of the table

 

[Fluff]

What value are you trying to lookup & what should happen if the value is found in multiple rows?

 

[vladi305]

What value are you trying to lookup & what should happen if the value is found in multiple rows?

On column 1 you have dates
On columns B to F you have numbers
I want to find the first value from the range from B to F and when that value is found return the date . Only 1 value to lookup and only one value to return which is the first value found

 

[Fluff]

You have not answered my questions, What value are you trying to lookup?

 

[vladi305]

You have not answered my questions, What value are you trying to lookup?

Yesterday I posted above: I want to for example lookup for value #3 on range from B1:F300

 

[Fluff]

Do you just want to look for the number, or do you want to put the lookup value in a cell (for instance G1) & use that?

 

[vladi305]

Do you just want to look for the number, or do you want to put the lookup value in a cell (for instance G1) & use that?

Yes the lookup value will come from a cell from another tab. It won't be hardcoded

 

[Fluff]

Ok, how about

=INDEX(A:A,AGGREGATE(15,6,ROW(A1:A100)/(B1:F100=G1),1))

where G1 has the value you want to lookup.

 

[vladi305]

Ok, how about

=INDEX(A:A,AGGREGATE(15,6,ROW(A1:A100)/(B1:F100=G1),1))

where G1 has the value you want to lookup.

Tested and it works perfect. Ty