Nikki91775
Member
Hi Everyone,
I am working on an excel spreadsheet where I need to lookup the value of 2 items. For example, I need to lookup everything that is a .25 for sales by the month, 1, 2, 3, 4, 5 and so on. So my vlookup is this:
=VLOOKUP(A4, Data!, MATCH('By Pump Size'!O2, Data!AK:AL, 2, False)),
A4 is my .25", the Data! is where my pivot table resides. By Pump Size!02 is where my month resides - say month 1.
I cannot get this to work. It keeps telling me I have an error in the formula. This is my first try at trying to get 2 values. Any help is appreciated.
Thanks.
I am working on an excel spreadsheet where I need to lookup the value of 2 items. For example, I need to lookup everything that is a .25 for sales by the month, 1, 2, 3, 4, 5 and so on. So my vlookup is this:
=VLOOKUP(A4, Data!, MATCH('By Pump Size'!O2, Data!AK:AL, 2, False)),
A4 is my .25", the Data! is where my pivot table resides. By Pump Size!02 is where my month resides - say month 1.
I cannot get this to work. It keeps telling me I have an error in the formula. This is my first try at trying to get 2 values. Any help is appreciated.
Thanks.