Vlookup,Index,Match,SumIF

rhchheda

New Member
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,
 

AhoyNC

Well-known Member
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]
 

Some videos you may like

This Week's Hot Topics

Top