Alternative for HLookup? Closed

Question

Configuration: Windows XP / Firefox 3.6


I am have been a excel VBA programmer from last couple of years, but not an expert in excel formula. Thought of taking your expert help!!

My question :

I have a situation where I have to lookup the field say emp grade in  a column match it against list of grades from another range and return the correnponding pakage from another range.  I cannot use Hlookups or vlookups as the columns are not static. Any pointers would be really a great help.

 
Grade        :                                                                                        :                             Package                         
Associate                                            
Associate                                            
Manager                                            
Sr Manager                                            
Deputy                                            
Sr. Deputy                        


L10:Q10  Grades     Associate    Manager    Sr Manager    Deputy    Sr. Deputy


L15:Q15	 Rank    	100    101    102    103    104
L16:Q16  Package    	A    	A+    B       B+    D

rizvisa1 · Answer

Could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee. Could you re-explain your question with example from that sample file

rizvisa1 · Answer

try this

=HLOOKUP(D8,J$7:P$14,8,FALSE)

Alternative for HLookup?

2 responses

Similar discussions

Subscribe To Our Newsletter!