Greetings to all!
I am trying to run a pivot table with a column having results of vlookup formula.
The vlookup formula on the base spreadsheet is :
=LOOKUP(2^15,SEARCH({"Overdue","Red","PastY","Yellow","Green","Complete","No_BL"},$J2),{"01","02","03","04","05","06","07"})
1st objective is for excel to read a column (J in this case) and populate the respective source cell column (I) with the appropriate number (from 01 thro 07).
Subsequently, I am trying to run a pivot on this column (I) value (01 thro 07) to group the pivot table data.
Unfortunately, pivot output is not picking any value from the source table column I, apparently due to the source cell format.
If I manually convert the value in column I to the appropriate number (from 1 thro 7), pivot works fine. However, I would not prefer to reformat each record in column I source cell.
Any advise on this issue?
Thank you in advance..
I am trying to run a pivot table with a column having results of vlookup formula.
The vlookup formula on the base spreadsheet is :
=LOOKUP(2^15,SEARCH({"Overdue","Red","PastY","Yellow","Green","Complete","No_BL"},$J2),{"01","02","03","04","05","06","07"})
1st objective is for excel to read a column (J in this case) and populate the respective source cell column (I) with the appropriate number (from 01 thro 07).
Subsequently, I am trying to run a pivot on this column (I) value (01 thro 07) to group the pivot table data.
Unfortunately, pivot output is not picking any value from the source table column I, apparently due to the source cell format.
If I manually convert the value in column I to the appropriate number (from 1 thro 7), pivot works fine. However, I would not prefer to reformat each record in column I source cell.
Any advise on this issue?
Thank you in advance..
