Forum Discussion
how do I do this formula in excel?
Hi Benet,
Since you don't define what shall be for number like 6.5 it looks like you consider only integers. If translate your range in form as in column B
the formula could be
=LOOKUP(F1,$B$1:$B$11,$D$1:$D$11)
and attached
Hi Benet,
Since you don't define what shall be for number like 6.5 it looks like you consider only integers. If translate your range in form as in column B
the formula could be
=LOOKUP(F1,$B$1:$B$11,$D$1:$D$11)
and attached
That's brilliant Sergei, works perfectly. You made that seem very easy!
Many thanks, Benet
You are welcome
I have another problem!
I have two lists with four choices in each list, and I want to return an associated value from a grid of numbers when I make a choice from each list.
The lists of choices are:
- None, open, perforated, solid
- a, b, c, d
The first list basically is the headings for the columns, and the second is the headings for the rows, and the grid is populated with associated numbers.
So when I make my choices (how is this best done - with tick boxes, or maybe a drop down menu?) I would like the number in the relevant grid square to be returned to the formula cell.
None
Open
Perforated
Solid
a
300
225
150
0
b
100
75
50
0
c
50
38
25
0
d
10
8
5
0
So for example if I choose c and open, I would return a value of 38.
Any assistance on how to do the choices and the number formula would be much appreciated!
