Forum Discussion
Need to calculate based on values from two separate drop down Lists
list of 16 cars, 16 brands and 16 different prices. I have a main sheet with my data, a second sheet with the table containing the drop down lists. My formula spills. I cannot for the life of me figu...
Lookup value here is an array, formula returns an array for which is not enough space in one cell of the table, thus #SPILL error
What other parameters mean is also absolutely unclear (second one is value instead of range, etc)