Hi there,

I need excel to automatically display a message box when opened. I need the message box to prompt the user for 2 inputs; in this case, 0 and 12.


Input Message Box:

How many 24AWG: 0
How many 22AWG: 12


Lookup Table:

A1 B1 C1
Num 24AWG 22AWG
1 A35 E24
2 A35 E25
3 A35 E26
4 A35 E27
5 A35 E28
6 A35 E29
7 A35 E30
8 B35 E31
9 B35 E32
10 B35 T33
11 B35 T33
12 B35 T33
13 B35 T33
14 B35 T33
15 B35 T33
16 B35 T54
17 B35 T55
18 C35 T56
19 C35 T57
20 C35 T58
21 C35 T59
22 C35 T60
23 C35 T61
24 C35 T62
25 C35 Y13
26 D35 Y56
27 D35 Y99
28 D35 Y142
29 D35 Y185
30 D35 Y228
Then I need a message box to display an answer based on the inputs and corresponding value in the lookup table.

Output Message Box:

Answer: T33


Any help would be greatly appreciated!

Thx,

Craig