Forum Discussion
Any Help Is Appreciated
Guys, Any help is appreciated, I don't deal with excel much, only on a very basic level. To most on here I'm sure this is very simple though this simpleton is lost. On my "Condenser Selection" sh...
Hi Stephen,
you can use a combination of the INDEX funciton with a negative approximate MATCH. For example, your formula in G6 would be '=INDEX('Daikin Data'!B$2:B$7,MATCH($F6,'Daikin Data'!$C$2:$C$7,-1))'. For the formula to work the data in the 'Daikin Data' sheet must be sorted by 'Cooling (kw)' column in a descending order.
Please find attached the file with a solution
Regards
Yury
Yury,
You're a legend, much appreciated.
Thank you
Stephen