I can't fix it self (Vlookup or whatever)

  • Thread starter Thread starter AQAA
  • Start date Start date
A

AQAA

Hello Guys,

First let me explain what I am trying to do

My worksheet looks like this


Code:
--------------------


A B C
--------------------------------------------
Articlenr. CustomName Percent
--------------------------------------------

1 Tom 10%
1 David 15%
2 John 30%
5 Dave 25%
2 Martin 20%

--------------------


I want to lookup A$2$ and B$2$ to get the 10%

So I did *(I am on row 10)*


Code:
--------------------


A B C
1 Tom =VLOOKUP(A10+B10;A2:B9;3;FALSE)

--------------------


And it doesn't work

Can someone help me with this?

ThankX in Advance
 
AQAA said:
A B C
--------------------------------------------
Articlenr. CustomName Percent
--------------------------------------------

1 Tom 10%
1 David 15%
2 John 30%
5 Dave 25%
2 Martin 20%

I want to lookup A$2$ and B$2$ to get the 10%
So I did *(I am on row 10)*

A B C
1 Tom =VLOOKUP(A10+B10;A2:B9;3;FALSE)

And it doesn't work
Can someone help me with this?
ThankX in Advance
Click to expand...

Try this array formula:
=INDEX(C2:C9,MATCH(A10&B10,A2:A9&B2:B9,0))
An array formula has to be entered using CTRL+SHIFT+ENTER rather than just
ENTER.
 
Hi

When the table you presented us is on Sheet1, ant the table's datarange is
A2:C100 (or less), and you want to find the according percent for cell on
another sheet, with values for Articlenr and CustomName in cells A10 and
B10, then:
=SUMPRODUCT((Sheet1!$A$2:$A$100=A10)*(Sheet1!$B$2:$B$100=B10)*(Sheet1!$C$2:$
C$100))


Arvi Laanemets
 
ThankX guys,..

I tested both of them and it works great, also done with multible
sheet,...works fine

Again thankx a lot Both of you guys

Aqaa
 
Back
Top