Prev: retrieving current data
Next: Conditional Format for Blank Cells
From: XKruodo on 18 Mar 2010 11:55
Hi,
I thought this was simple and i could google it. but could not find a
solution.

Age 3 ( premium per years) 5 ( premium per year)
etc etc
1 5000
7000 9000
2
3
4
etc in years

A cell where i can enter AGE and another cell where i can enter 3 or 5 or
etc years..

From: Pete_UK on 18 Mar 2010 12:46
Assuming Age is in A1 and the other headings (numbers only) are in row
1 to column H. Use M1 for Age sought and N1 for years and put this
formula in O1:

=VLOOKUP(M1,A$1:H$100,MATCH(N1,$A$1:$H$1,0),0)

In future, tell us what cells you are actually using and then you will
get a specific answer rather than one you have to adjust to suit your
real data layout.

Hope this helps.

Pete

On Mar 18, 3:55 pm, XKruodo <XKru...(a)discussions.microsoft.com> wrote:
> Hi,
> I thought this was simple and i could google it. but could not find a
> solution.
>
> Age                     3 ( premium per years)   5 ( premium per year)      
> etc etc
> 1                                  5000                                  
> 7000                         9000
> 2
> 3
> 4
> etc in years
>
> A cell where i can enter AGE and another cell where i can enter 3 or 5 or
> etc years..

From: XKruodo on 18 Mar 2010 23:41
Worked fine..
Thanks.

"XKruodo" wrote:

> Hi,
> I thought this was simple and i could google it. but could not find a
> solution.
>
> Age 3 ( premium per years) 5 ( premium per year)
> etc etc
> 1 5000
> 7000 9000
> 2
> 3
> 4
> etc in years
>
> A cell where i can enter AGE and another cell where i can enter 3 or 5 or
> etc years..
>
 | 
Pages: 1
Prev: retrieving current data
Next: Conditional Format for Blank Cells