Find Column Value from Lookups

[RazzPrince]

Many time user....first time poster

I am looking to return a column value from a single row based on two variable (one in rows and one in columns). Hopefully it makes more sense in the table!
I have 'over engineered' a solution but hoping for something more streamlined to save workbook bulk also looking for a non VBA solution.

Thanks if you can help!!

Ref A	1	5	5	6
Ref B	1	2	3	4
Ref C	1	3	4	4
Ref D	1	2	2	7
Ref E	1	7	7	7
Required Value from this row	Apr18	May18	Jun18	Jul18

<tbody>
</tbody>

So from this data I need to return the Month from the Ref in Column A and then the number from Column B to E.

So if my variable were Ref B and 3, my formula would return Jun18.
If variable Ref D and 7, this would return Jul18.

My current formula works for Ref B and 3 by doing If("Ref B"=A1,Hlookup(3,B1:E1,6),if"Ref B"=A2,Hlookup(3,B1:E1,5),ETC)).

Scratching me head on this one so would appreciate any help/ suggestions! Hopefully I am missing the obvious.


Thanks,

 

[Oscar Cronquist]

	A​	B​	C​	D​	E​	F​
1​	Ref A	1​	5​	5​	6​
2​	Ref B	1​	2​	3​	4​
3​	Ref C	1​	3​	4​	4​
4​	Ref D	1​	2​	2​	7​
5​	Ref E	1​	7​	7​	7​
6​	Required Value from this row	18-Apr​	18-May​	18-Jun​	18-Jul​
7​
8​	Condition1	Ref A		Formula:
9​	Condition2	1​		18-Apr​
10​

Sheet: Sheet18

Formula in cell D9:
=INDEX($B$6:$E$6,MATCH($B$9,INDEX($B$1:$E$5,MATCH($B$8,$A$1:$A$5,0),0),0))

 

[RazzPrince]

Thanks a million for this! It makes sense now its 'spelt' out!

One more question if you can help...... If condition 2 was the number 4 (ie number less than 5), can the formula be updated to still pull back Apr-18 (if the condition is not an exact match)?