Vlookup,Index,Match,SumIF

rhchheda

New Member
Joined
Oct 15, 2019
Messages
1
Hi Excelperts,
Need help on following try to create a dashboard.

Have herewith attached a sample file

But first need to match data from Column H to A of Sheet 'Oct-19'
On dashboard need following data are to be Displayed with the help Index on Sl-No in column G of Sheet 'Oct-19'
& lock/protect the data sheets "User Front only Dashboard should be available"

Product Name
Batch
Rate
Qty
Date
Invoice#
Difference of Qty from column B & K of Sheet 'Oct-19'

from Column G,H,I & J & A,B,C,D,E,F & G

Appreciate your inputs/help.

Link to sheet https://docs.google.com/spreadsheets/d/1A7bG-_E9T3GK7-V1ii60eoLEv36wcVBK_iAVevm1KY8/edit?usp=sharing


Thanking you,
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
I see a couple of potential problems with your formula.
1- I think you have your INDEX and MATCH range reversed.
2- The value 11 in cell F4 of the DashBoard is numeric and the column SI-No is text, so it will not find a match.

Once you correct either F4 to text or the SI-No column to numeric then try the formula below.

Code:
[TABLE="width: 475"]
<colgroup><col width="475"></colgroup><tbody>[TR]
   [TD="width: 475"]INDEX('Oct-19'!J3:J354,MATCH(DashBoard!F4,'Oct-19'!I3:I354,0),0)[/TD]
 [/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,952
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top