Forum Discussion
Query related to HLOOKUP or INDEX with MATCH function
Hello Everyone, I have a data, which i want match data to Commission $ column. Can we use HLOOKUP or INDEX with MATCH function(both way) to making more dynamic ? Please help.. Here...
Based on your file you can use INDEX/MATCH like-
=INDEX($J$5:$Q$5,MATCH(B2,$J$4:$Q$4,0))