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
Thanks and Regards
Pranil
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
Thanks and Regards
Pranil