-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
#vlookuphelp
-
F
Life Insurance Premium Calc with age band
Hello, I would like to get help with calculating life insurance premium/cost where the cost is based on age band and coverage amount is in units of $1,000. Please see attached sample sheet. If a person enters his/her age and desired coverage amount in cell B1&B2, the formula looks at rate chart...- Freshta01
- Thread
- #excel #vlookuphelp
- Replies: 8
- Forum: Excel Questions
-
B
ifna formula in Power Query - replace multiple/alternate vlookup
Hi, I have some formula's that I am trying to replace using Power Query.... not sure what the best way to explain this is but I will explain the scenario in excel first. I need to look at column 1 and return the value specified in the lookup table, but if the number doesn't exist in column 1...- blackduck
- Thread
- #formula #ifna #powerquery #vlookup #vlookuphelp
- Replies: 2
- Forum: Power Tools
-
S
Data migration using vlookup is not working
Hi friends, I need to migrate matching data from one file to another file, since i have more than 6000 datas to migrate, i need a formulae to facilitate my process, so i tried the vlookup formula, =VLOOKUP(A2,'[SAMPLE 1.xlsx]Sheet1'!$B$2:$B$10,2,FALSE) Its not working:-( Please...- sadeeshskl
- Thread
- #datamigration #matchingdatamigration #vlookuphelp
- Replies: 5
- Forum: Excel Questions
