Using LOOKUP, MATCH, INDEX to obtain cell value from data table

Hi guys,

I am looking to use a function in my spreadsheet to find a value based on two things: 1) model number and 2) pressure. These values are found in cells on a spreadsheet and the data table is another spreadsheet within the same workbook. So an example of data is as follows:

Pressure
Model# 40 50 60 70 80 90 100 110 120 130 140 150
GBV315 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" N/A N/A N/A
GBV420 1/4" 1/4" 1/4" 1/4" 3/8" 3/8" 3/8" 3/8" 3/8" N/A N/A N/A
GBV520 1/4" 1/4" 3/8" 3/8" N/A N/A N/A N/A N/A N/A N/A N/A
GBV525 1/4" 3/8" 3/8" 1/2" 1/2" 1/2" 1/2" 1/2" 1/2" N/A N/A N/A
GBV725 1/2" 1/2" 1/2" 1/2" 1/2" N/A N/A N/A N/A N/A N/A N/A
GBV315 SR40 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4"
GBV315 SR60 N/A 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4"
GBV315 SR80 N/A N/A N/A 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4"
GBV315 SR100 N/A N/A N/A N/A N/A 1/4" 1/4" 1/4" 1/4" 1/4" 1/4" 1/4"

Preferably, if supply pressure is, say 62.4, I would want it to automatically round up to supply pressure for 70.
Also, is it possible to still look up GBV315 SR40 if someone mistakenly puts in GBV315-SR40 (there's a bit of confusion with regards to nomenclature used to describe these models)

Am I in the right direction here starting with the functions listed in the subject? Thanks for any advice guys!

Here you go

Thanks for all your help! It worked for the dummy data I gave you, however, I've realized I made a mistake in the data I supplied. As I continue to input data, I've realized that the next increments (25 instead of 10) result in an error. I've uploaded an updated data set.

Eureka! Thank you so much!!!

thanks icestationzbra; I had just come to the same realization upon further testing. gah! and thanks again!

success! thank you once again for all the direction!!

@ rfernandes

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.