Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
My initial spreadsheet contains a table of information, I am trying to create
a new spreadsheet with a cleaner version of the information. I am trying to use the INDEX and MATCH functions; however, to return my values I must consider three constants: customer, product, and date. So far I have only been able to find a way to use two constants. All three must be considered because many customers purchase a variety of products. The date is horizontal while customer and product are both vertical. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |