Help with formula to fetch data in Columns in Series

prnambiar

New member
Joined
Mar 27, 2017
Messages
2
Reaction score
0
Points
0
Dear Friends,

I have a Data table which has the car with a suffix indicating its shift (its quite long table), I would like to get the value from Column-H "DISP ST" of this
table on another table "To be Solved", against its CAR+Shift and against the particular dispatch date. I have to do this exercise to analyse the dispatch status of the car during assessment year for each shifts. Though I tried Pivot the Dispatch status values are appearing in number. Though I read in several post about using pivot and custom formatting of text to convert the number to texts, I am looking for some other methods "may be using Vlookup function in combination with other formulas" to fetch the required text data

Appreciate your valuable suggestions to resolve my problem



Help with formula-1.jpg

Thanks and Regards
Pranil
 

Attachments

  • Help on Formula.xlsx
    10.6 KB · Views: 17
Dear Mr. Hossat,

Thanks a lot for your help. I am able to prepare the required reports now :peace:

Pranil
 
Back
Top