How To Look Up Values Using The MAX & IF Function Combination In Excel

Here we are going to use the MAX and IF functions in combination to look up a value in an array. We will also incorporate the INDEX and COLUMN functions to assist us.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , , , ,

No comments yet.

Leave a Reply