Hello. I have a sheet that I put together and I the sheet I have a table for which there are two rows and 5 columns. I created dropdowns to basically choose any row and any column and then return the corresponding value, however I cannot quite figure out the best way to do it. I know I can make an enormous nested if but that is not the best way. I am figuring it would use the INDEX and MATCH functions, but I cannot figure out exactly how to execute it. Can anyone point me in the right direction? Table is right in the middle. Thanks.
Bookmarks