I am trying to figure out a formula that will return the highest value in a range if the corresponding cell is a certain text.
It looks like this
A B
91 FB
82 CH
79 CH
89 FB
77 CH
83 CH
90 FB
So I named the whole range Pitcher1 and tried this formula “=VLOOKUP("CH", MAX(PITCHER1), 3, FALSE)”, but I am getting N/A back… I have tried IF before VLOOKUP as well and that isn't working...
please help!!!
Bookmarks