Log In
Register
Home
February 11, 2015
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
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
February 11, 2015
Offline
Sunny
Thank you so much. Yes, this worked great.
Have a great day.
Thanks again
Amy
New Member
July 22, 2021
Offline
Answer: This answer goes into detail on how to find the formula for the VLOOKUP in Excel.
Vlookup is a powerful tool that's best used for these types of scenarios
-You want to take information from one worksheet and insert it into another
-You need to compare two lists or tables, sometimes called a "compare columns" operation
-When you want to extract just the records you need (e.g., customers who live in Lincolnshire) from a larger dataset (e.g., all UK residents)
For more information go here https://www.exceltrick.com/for.....-in-excel/
1 Guest(s)
