Untitled-1.jpg
What I want is a something like a vlookup inside a vlookup that will help me
First, to find the corresponding "bank"
Second, Find which values does it falls in
So E.g.
A10 is equal to $2,000,000, falls under Bank "B"
So I need to look up for Bank B first
Secondly, it will need to correspond to " above 1,000,000"
So in the end I will get "0.1"
Thank you very much :D
The links to the sheet is https://docs.google.com/spreadsheet/...1E&usp=sharing
Bookmarks