What is the syntax to lookup values in a pivot table? My pivot table has the columns product, monday, tuesday, wednesday, etc. Rows are product name and sum of sales by weekday.
I can use vlookup to search the cells as static references. There seems like there should be a a way to search as though it were a table with column headings [#headers} or something similar. Any thoughts?
I can use vlookup to search the cells as static references. There seems like there should be a a way to search as though it were a table with column headings [#headers} or something similar. Any thoughts?