Using a numeric cell input to reference a matching cell in a table.

Hi,
I would like to use a cell to input pH information. From that information, I want excel to recognize and match the number to a table. Once the number is matched, I want to reference the adjacent column for use in a formula. I'm attaching my excel sheet. More descriptly, I would like to type 2.9 (for example) into G8. Then, in G9, I would like to write a formula that references the table (A14:24;B14:24); if 2.9 is entered, then the value 7.5 should arise. I can easily do this for one row, but cannot figure out the method for searching through the entire table. Thank you for your help!Additions.xlsx

Have you tried vlookup?

Formula:

Please Login or Register  to view this content.

No! I've never used vlookup, but now I will with much frequency. Thank you so much!

Cool.. And if you are planning to drag it to other cells, don't forget to use $. =vlookup(G8,$A$14:$B$24,2,false). When you drag it, A14:B24 will remain same.

And if your problem is resolved, please make this post as solved.