Previous Topic Next Topic

Alternative for HLookup?

Closed
kuldeps - 9 May 2010 à 06:28
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 9 May 2010 à 17:05



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
Related:

2 responses

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
9 May 2010 à 08:33
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
kuldeps
9 May 2010 à 09:55
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,
Réponse 2 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
9 May 2010 à 17:05
try this

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

Similar discussions

don't know alternative email
sufian -
BunoCS -

1 response