customised dashbord

poush

New member
Joined
Aug 16, 2016
Messages
1
Reaction score
0
Points
0
hi everybody,

I am trying to create customised dashboard with excel sheet. i tried with lookup, pivot and drop down list but unable to get desired output. can anybody advised me how to create this

attached herewith sample data and output I am looking. I need .................

1. "PRODUCT ID" OR "CENTRE" COLUMN AS INPUT CELL IF I ENTER VALUE IN ONE OF THE CELLS ALL OTHER DETAILS SHOULD APPEAR
2. IF IN "NATURE" ANY PRODUCT ID SHOWS HAS "SURRENDER" THEN TYPE COLUMN SHD BE "SURRENDER" OR "LIVE"

hope I could explain the query properly still if it needs further clarification pl do mention...

thkx - waiting for your help
 

Attachments

  • customised.dashbord.xlsx
    10.4 KB · Views: 45
Back
Top