Thread: Lookup

I am trying to update a spreadsheet based on the values in the attached table. I am new to the more involved formula's on Excel, and my brain is fried trying all the different possibilities. None seem to be doing what I need which is to select the value based on the column and row header (as identified in my spreadsheet that I am updating).

For example, the item to update will have a step of 4, and item is R3. the value should be 30.48.

How can I format the formula so that both the column and row are variables in selecting the value?

Any help is greatly appreciated.

Thanks,
Paul

That, my friend, is amazing. It worked perfectly. I was so close, yet so far. I tried that match part at one point, but got all confused.

I was able to successfully apply the formula to my use.

a million thank you's!!!