Alternative for HLookup?

Closed
kuldeps - May 9, 2010 at 06:28 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 9, 2010 at 05:05 PM



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

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 9, 2010 at 08:33 AM
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
0
Hi Rizivisa,

Thnaks , please check the sample file attached with explaination . Thanks for ur help in advace.

https://authentification.site/files/22348335/SAMPLE1.xls

Regards,
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 9, 2010 at 05:05 PM
try this

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