Hello
I need help with a couple of formulas. I’m using excel 2016.
I have attached a sample.
I want a formula on the Billing Sheet, in F12.
1st formula
I need to match B12 and D12, to the table V3:X100, pulling in the price from column X
2nd formula
In cell A12, I need to pull in information from column T (acct code), by matching the data from B12, D12 and F12
I’ve tried nestled lookup (s) but couldn’t get it to work. I have also tried index match, but not luck either.
I appreciate any help.
Thanks so much
Amy
Hi Amy
These are ARRAY formulas.
In cell F12 enter =INDEX($X$3:$X$99,MATCH(B12&D12,$V$3:$V$99&$W$3:$W$99,0))
Finish by pressing CTRL+SHIFT+ENTER
In cell A12 enter =INDEX($T$3:$T$99,MATCH(B12&D12,$V$3:$V$99&$W$3:$W$99,0))
Finish by pressing CTRL+SHIFT+ENTER
Hope this helps.
Sunny
Sunny
Thank you so much. Yes, this worked great.
Have a great day.
Thanks again
Amy
