Vlookup with match formula

[Arup Dutta Chowdhury]

Hi,
I have got a excel file in which there are two sheets. First sheet consist of different model name of mobile phones. In the second sheet it consists model wise sale figure. Now I want to do vlookup with match formula to extract model wise sale report. Both sheet have common CSR code. Please help .

 

[Arup Dutta Chowdhury]

Can anyone help.

 

[Juniad]

How you are manual calculating entries in Devices Sales report as there is no devices record in MTD sheet.

 

[Juniad]

=IFERROR(VLOOKUP($B2,'Devices Sales'!$B$5:$DL$1302,MATCH(Q$1,'Devices Sales'!$B$5:$DL$5,0)),"")
copy the formula and paste in MTD sheet in Q2 cell and drag over and down.

 

[Arup Dutta Chowdhury]

Thank You.