How could I create a two point lookup?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a series of tables that are based on product specific numbers on the
y-axis, and month/date combos on the x-axis.

How can I do a lookup that will so that I could find Product A's datapoint
for a specific month?

(essentially looking up the product number and then month and finding the
datapoint where the cross section one another)

Any suggestions?

thanks so much.
 
Chase said:
I have a series of tables that are based on product specific numbers on the
y-axis, and month/date combos on the x-axis.

How can I do a lookup that will so that I could find Product A's datapoint
for a specific month?

(essentially looking up the product number and then month and finding the
datapoint where the cross section one another)

Any suggestions?

thanks so much.
Click to expand...

Have a look here:
http://www.cpearson.com/excel/lookups.htm#DoubleLookup
 
Back
Top