Hey, i need some help returning a value based on multiple criteria. My workbook is set up as attached demo but I cannot figure out how to use array functions to return the rate from sheet 2 based on country and code as the criteria are both in rows and columns. Thanks for any help
Last edited by boyspalm; 11-11-2020 at 05:50 PM.
Welcome to the forum.
A basic INDEX MATCH MATCH:
=INDEX(Sheet2!$B$2:$E$5,MATCH(B2,Sheet2!$A$2:$A$5,0),MATCH(A2,Sheet2!$B$1:$E$1,0))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks so much. I amended the formula for my actual workbook and the cells return an N/A error although it's the exact same format. I've tried it for one row of values and it works but as soon as I copy the formula down, it returns N/A in all other cells
You've marked this as solved - is it?
If not, provide an updated workbook showing the issue. Most likely a mismatch - do you have any leading or trailing spaces anywhere?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks