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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,482
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,782
Messages
5,446,469
Members
405,403
Latest member
horace james

This Week's Hot Topics

Top