R
Ray
How would I create a formula that uses 'User input' as the criteria to
find the designated data on another sheet? Here's an example:
Say I have sales data for cars. A user can choose to see total sales
on 'Make' (ie Honda) or 'Model' (ie Accord), or 'Make/Model' (Honda
Accord). Assume for this example that other manufacturers make an
'Accord', so 'Accord' and 'Honda Accord' would return different totals.
I've already got drop-downs created for Make & Model that contain the
possible options. But how do I structure the VLOOKUP to use these
user-entered values? When I try it the 'normal' way, the VLOOKUP
doesn't recognize a blank cell (ie a Make but no Model) as blank -- it
evaluates the cell as '0'.
Any ideas? I know that VLOOKUP may not be the best way to do, but it's
what I knew how to do...
TIA, Ray
find the designated data on another sheet? Here's an example:
Say I have sales data for cars. A user can choose to see total sales
on 'Make' (ie Honda) or 'Model' (ie Accord), or 'Make/Model' (Honda
Accord). Assume for this example that other manufacturers make an
'Accord', so 'Accord' and 'Honda Accord' would return different totals.
I've already got drop-downs created for Make & Model that contain the
possible options. But how do I structure the VLOOKUP to use these
user-entered values? When I try it the 'normal' way, the VLOOKUP
doesn't recognize a blank cell (ie a Make but no Model) as blank -- it
evaluates the cell as '0'.
Any ideas? I know that VLOOKUP may not be the best way to do, but it's
what I knew how to do...
TIA, Ray