VBA code for Index Match function

[dss28]

I am using Index match function in excel to retrieve values from a sheet ("MasterData") to another sheet ("Report") using a specific unique number which the user enters in a cell in sheet "Report" . This populates a table with about 6 columns and 15 rows as per the data available in "MasterSheet" for that particular unique number.

for this I have entered this formula in each of the cells in sheet "Report" in the 15x6 rows/ column table.

formula is :

{=INDEX(MasterData!C:C,MATCH($E$7&"|"&$C$14,MasterData!F:F&"|"&MasterData!H:H,0))}

In this formula the cell reference $E$7 and $C$14 is in sheet "Report".

The user enters the specific unique code in cell C14 which then matches the values of each row reference cell E7 to pull the corresponding values in the table on this sheet.

Now I want to convert this formula to vba code.

can any body help me to convert this in vba code:

 

[dss28]

Can you post a screen shot of the MasterData please, or load with xlbb

 

[dss28]

Can you post a screen shot of the MasterData please, or load with xlbb

 

[dss28]

index match function vba code.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Column A Heading	Column B Heading	Column C Heading	Column D Heading	Column E Heading	Column F Heading	Column G Heading	Column H Heading	Column I Heading	Column J Heading	Column K Heading	Column L Heading	Column M Heading	Column N Heading	Column O Heading
2						fd001		1
3						fd001		2
4						fd001		3
5						fd001		4
6						fd002		1
7						fd002		2
8						fd002		3
9						fd002		4
10						fd002		5
11						fd003		1
12						fd003		2
13						fd003		3
14						fd003		4
15						fd003		5
16						fd003		6
17						fd003		7
18						fd003		8
19						fd004		1
20						fd004		2
21						fd004		3
22						fd004		4
23						fd004		5
24						fd004		6
25						fd004		7
26						fd004		8
27						fd004		9
28						fd004		10
29						fd004		11
30						fd004		12
31						fd004		13
MasterData

 

[dss28]

sheet "MasterData" in the previous post and Sheet Report below

index match function vba code.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2
3
4
5
6
7				Colmn F Heading
8
9
10
11
12
13			Colmn H Heading	Colmn C Heading	Colmn F Heading	Colmn G Heading	Colmn K Heading
14			1
15			2
16			3
17			4
18			5
19			6
20			7
21			8
22			9
23			10
24			11
25			12
26			13
27			14
28			15
29
30
31
Report

 

[offthelip]

That looks identical to my workheets. Where have you put the code? You should put in a standard module NOT in the worksheet code.

 

[dss28]

That looks identical to my workheets. Where have you put the code? You should put in a standard module NOT in the worksheet code.

yes, great , that worked.. ..realised the mistake
thanks