vlookup & hlookup help??

**331** · 10-14-2012, 04:28 PM

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!

**FDibbins** · 10-14-2012, 05:11 PM

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?

**331** · 10-14-2012, 09:40 PM

I'm taking your advice for using match/index.

THANK YOU SO MUCH!!
Much appreciated =)

**FDibbins** · 10-14-2012, 10:05 PM

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)