I'm really not even sure how best to word what I'm trying to do. I don't have any code to post just a picture (I know!) of a table to be used.
I have created a userform to input information into a spreadsheet. Based on that info entered, I need to create a code that will search the following table and multiply an entry by the number in the cell.
Example: If textbox1 (age) is 63 and textbox2 (column header) is "3SI" is it possible to retrieve the cell value in cell E5 via a macro? Essentially, I need to be able to search any combination of age and column header and then utilize the intersecting value.
I realize this is asking a lot since I don't even have any code. I'm happy to read/watch tutorials. I just don't know how to concisely ask the question to find the answer.
image_2020-11-30_135524.png
Bookmarks