I would like to write a formula that uses more than two variables for an expression, I've attached a spreadsheet to show what I'm thinking of. I had been using nested IF statements to make things like that work, but I'm hoping that with the more recent releases of Excel that there is something simpler that can do the same thing.
Here's what I have
Managing multiple variables.xlsx
I'm not sure exactly what you are looking for, since it does not seem to be included in the sample that you have provided.
That being said, I think you are looking to return the corresponding values of the variables in the array table under where it says "Calculation table".
If so, put this formula in J2 and drag over and down:
=INDEX($B:$B,MATCH(D2,$A:$A,0))
Alternatively, you can put this array formula in J2, and have it auto-spill into the proper number of cells instead of dragging formulas:
=XLOOKUP(D2:E3,A2:A8,B2:B8)
Last edited by 63falcondude; 10-03-2023 at 01:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks