Hi.
The lookup functions on excel do not satisfy my requirements.
I have two columns then data, like this:
Class Type NPols
ANN 507 100
ANN 508 123
ANN 552 6903
ANN 548 1234
ANW 507 4520
ANW 508 23520
ANW 510 2420
*** 507 5285
*** 509 2520
*** 510 2343
Now, I want to retrieve the data NPOLS for "*** 507" say so the function would pick out 5285.
Any help on this appreciated. I don't want a VBA solution sorry I want to be able to do this on the worksheet if possible.
A related problem was the following, I had data like this
Year Policy Data1 Data2
1991 Life 2345 42420
Pension 2355 2449
1992 Life 94802 42420
Pension 4295 24249
1993 Life 2420 63729
Pension 24020 74240
etc.
and I just couldn't come up with a lookup solution to find Data2 for 1992 Pension say. The required function would give me 24249.
Again, I just can't change the labels and I require a lookup solution, not VBA please.
Many thanks,
RET79
This message was edited by RET79 on 2002-05-09 12:18
The lookup functions on excel do not satisfy my requirements.
I have two columns then data, like this:
Class Type NPols
ANN 507 100
ANN 508 123
ANN 552 6903
ANN 548 1234
ANW 507 4520
ANW 508 23520
ANW 510 2420
*** 507 5285
*** 509 2520
*** 510 2343
Now, I want to retrieve the data NPOLS for "*** 507" say so the function would pick out 5285.
Any help on this appreciated. I don't want a VBA solution sorry I want to be able to do this on the worksheet if possible.
A related problem was the following, I had data like this
Year Policy Data1 Data2
1991 Life 2345 42420
Pension 2355 2449
1992 Life 94802 42420
Pension 4295 24249
1993 Life 2420 63729
Pension 24020 74240
etc.
and I just couldn't come up with a lookup solution to find Data2 for 1992 Pension say. The required function would give me 24249.
Again, I just can't change the labels and I require a lookup solution, not VBA please.
Many thanks,
RET79
This message was edited by RET79 on 2002-05-09 12:18