Hello all,
I'm new at Excel, and I'm trying to calculate/find discount in my assignment. I have given up hope
Can anyone help?
I think I need to somehow link vlookup & hlookup, not to sure how.
Thanks in advance!
Hello all,
I'm new at Excel, and I'm trying to calculate/find discount in my assignment. I have given up hope
Can anyone help?
I think I need to somehow link vlookup & hlookup, not to sure how.
Thanks in advance!
1st of all, i moved your "sales value" table up 1 row to match up with your "units sold" table.
why you would want to use a combined vlookup/hlookup is beyond me, you could do what you want far easier with index/match
=ROUND(INDEX('Step 1 Data'!$A$10:$H$15,MATCH('Step 1'!B11,'Step 1 Data'!$A$10:$A$15,1),MATCH('Step 1'!D11,'Step 1 Data'!$A$10:$H$10,1)),4)
however, if you insist on using vlookup/hlookup, try this. 1st i added a helper row A16:H16 and filled it with sequential numbers for the hlookup. then i used thisr...
=ROUND(VLOOKUP(B11,'Step 1 Data'!$A$10:$H$15,HLOOKUP(D11,'Step 1 Data'!$A$10:$H$16,7,TRUE),TRUE),4)
you can copy this down. let me know how you make out?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I'm taking your advice for using match/index.
THANK YOU SO MUCH!!
Much appreciated =)
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks