If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VLOOKUP with HLOOKUP
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.. |
#2
|
|||
|
|||
VLOOKUP with HLOOKUP
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 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.. |
#3
|
|||
|
|||
VLOOKUP with HLOOKUP
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.. |
Thread Tools | |
Display Modes | |
|
|