IF condition on table with multiple criteria

[Ammara143]

Good day,

I've been stuck on this for a while and can't find anything useful online.

I have a table that I have ranked from 1 onwards - now I need to make a chart for the Top 10 only.
I have created another table just for the Top 10 to feed the chart.

My problem comes in the second table where I need to pull the data from the first table (that has been ranked, but not in order as it is sorted by branch, not rank)
I am using nested IF function, but it is well over 100 of these.

Is there an easier formulae to draw from columns and tables?

Hope all this makes sense.

Excel.xlsx
	H
27	9
FB Stats_all

 

[Ammara143]

So I cannot have more than 64 nested IF conditions - I need 116