HI,
I'm trying to figure out how to write a formula that will look down through Range(A5:A16) and find the value in cell A2. The next step is to look accross C3:H3 and find the value in cell A3.
Here is the tricky part. The value in A3 needs to be found between the number value in the Range (C3:H3). The fomula is meant to work the sale way as a times table.
C35,000
D3 25,000
E3 100,000
F3 499,999
G3 100,000
H3 5,000,000
Thank you for any help
I'm trying to figure out how to write a formula that will look down through Range(A5:A16) and find the value in cell A2. The next step is to look accross C3:H3 and find the value in cell A3.
Here is the tricky part. The value in A3 needs to be found between the number value in the Range (C3:H3). The fomula is meant to work the sale way as a times table.
C35,000
D3 25,000
E3 100,000
F3 499,999
G3 100,000
H3 5,000,000
Thank you for any help