Loop that finds a value based on user input

Hi everyone,

I am a VBA beginner and I am facing an issue right now. I need to write a code that finds a value within a table based on the row and column where it is located.

PROBLEM.JPG

Upper left corner of table is located in A1

I am supposed to input a number from 1 to 10 (leftmost column), then a letter from A to G, and based on those inputs I have to display the number. So for instance, if I input 1 and A, the number displayed should be 6.

How do I do this? It's supposed to be done with loops, and it's doable without using array constructions.

Thank you in advance.

How to know where your table is ???

Try

Please Login or Register  to view this content.

Note: in next code it assumes that row 1 with letters and column 1 with numbers are part of the table

Please Login or Register  to view this content.