Match values from pivot table to normal table

[skatman]

I need to ask if it's possible to match value from pivot table item with value in another normal table and return the value from another column.

Example:

I have this pivot table with this "account" id slected

and in 2nd worksheet i have this table

And i would like to know if it is possible in VBA to compare the value selected in pivot table to the 2nd table and if the id is in the table return the email adress from that ID?

 

[gelu]

Hi Skatman,

Please use XL2BB - Excel Range to BBCode to post values.
Otherwise people need to type your data in order to help and that is a bother.


No need for VBa to achieve that.

Imatch pivot.xlsx
	A	B	C	D	E	F	G
1
2
3	Acc	Customer	a	d	f	t	Email
4	35348	c2	abc1	abc2	abc3	abc4	c2@abc.com
5	35353	a4	abc1xx	abc2xx	abc3xx	abc4xx	a4@abc.com
6
7
8	ID	Name	Email
9	35348	c2	c2@abc.com
10	35353	a2	a2@abc.com
11	35358	a3	a3@abc.com
12	35363	a4	a4@abc.com
Sheet4

Cell Formulas
Range	Formula
G4:G5	G4	=INDEX($B$9:$C$12,MATCH(B4,$B$9:$B$12,0),MATCH($G$3,B$8:C$8,0))
A5,A10:A12	A5	=A4+5
C5:F5	C5	=C4&"xx"
C9:C12	C9	=B9&"@abc.com"