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,
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,475
Office Version
365
Platform
Windows
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]
 

Watch MrExcel Video

Forum statistics

Threads
1,095,381
Messages
5,444,124
Members
405,269
Latest member
Kjtakke

This Week's Hot Topics

Top