# Excel - VLOOKUP Help

The final ranking needs to be determined by the following
Type of data
BIA Tier
Number of Records
Frequency

Currently the Final Rank is determined by
Type of data
Number of Records
Frequency

But not BIA Tier

How can i get the BIA Tier to be added into determining the Final Rank?

Please note that the Initial Rank is only determined by
Type of Data and BIA Tier

This is a followup to a question i asked a month ago
here is the original question

https://www.experts-exchange.com/questions/27869460/Excel-Formula.html

buttersk was kind enough to help me out in my original question.
Ranking-Process.xlsx
NBVC

Update K2 in Source file to:

=IF(N2="NA",CONCATENATE(L2,M2,O2),CONCATENATE(L2,M2,N2,O2))

and copied down

then update H2 in Sheet1 to:

=IF(ISNA(VLOOKUP(CONCATENATE(E2,F2,B2,C2),FinalRankLookup,5,FALSE)),"",VLOOKUP(CONCATENATE(E2,F2,B2,C2),FinalRankLookup,5,FALSE))

copied down
sammenace

NB_VC

I tried what you told me but in the final raking it says "Tier 1" instead of the rank such as critial.

any idea?
1-Ranking-Process.xlsx
Not for points......

presumably you could simplify that H2 formula by using IFERROR, i.e.

=IFERROR(VLOOKUP(E2&F2&B2&C2,FinalRankLookup,5,0),"")

regards, barry
NBVC

membership
Create an account to see this answer
Signing up is free. No credit card required.