spacing gets screwed up when I submit, so you'll have to visualize...
across the top is "Truck" "dog" and "bike", down column A is colors, and in the middle of the grid is number values.
if this was my spreadsheet, I'd like to be able to wite a formula that would return "4" if given "orange" and "dog".
is this possible?
I was thinking an Hlookup combined with some function that I don't know about yet that could locate "orange" and return the value of which row it's on.
any ideas?
across the top is "Truck" "dog" and "bike", down column A is colors, and in the middle of the grid is number values.
if this was my spreadsheet, I'd like to be able to wite a formula that would return "4" if given "orange" and "dog".
is this possible?
I was thinking an Hlookup combined with some function that I don't know about yet that could locate "orange" and return the value of which row it's on.
any ideas?