Hi Guys
Please could you let me know if there is an equation that I can use to help speed up "data entry" in to a spreadsheet.
In essence I have a spread sheet where all the information needs to be entered manually in order to arrange a premium.
Is there an equation that can be used that would do the following:
If the Insurance Code was entered as 1
The rates that apply to that code were entered in the relevant sections. For example:
Buildings would automatically show .40
(Currently using =IF($H$3=Rating!$B$1,Rating!$B$3,0) as a testing tool)
$H3$ is the insurance code
$B$1 is confirming the insurance code
$B$3 is the rate that applies to buildings
I would need the spreadsheet/equation to be able to know that if a different insurance code was entered then different rates would apply.
There are 10 sections to the spreadsheet (I appreciate I can hopefully reuse the same formula for the difference sections, by creating multiple tables of data)
The issue with using =if (only ever used as a testing tool) is that there can only be 7 equations used. There are approximately 95 insurance codes.
I have tried to play with VLOOKUP but it doesn't seem to fit what I need, or cannot find the data required.
Hope this make sense and also hope you guys can help.
Look forward to hearing from you.
KR
Creaky
Please could you let me know if there is an equation that I can use to help speed up "data entry" in to a spreadsheet.
In essence I have a spread sheet where all the information needs to be entered manually in order to arrange a premium.
Is there an equation that can be used that would do the following:
If the Insurance Code was entered as 1
The rates that apply to that code were entered in the relevant sections. For example:
Buildings would automatically show .40
(Currently using =IF($H$3=Rating!$B$1,Rating!$B$3,0) as a testing tool)
$H3$ is the insurance code
$B$1 is confirming the insurance code
$B$3 is the rate that applies to buildings
I would need the spreadsheet/equation to be able to know that if a different insurance code was entered then different rates would apply.
There are 10 sections to the spreadsheet (I appreciate I can hopefully reuse the same formula for the difference sections, by creating multiple tables of data)
The issue with using =if (only ever used as a testing tool) is that there can only be 7 equations used. There are approximately 95 insurance codes.
I have tried to play with VLOOKUP but it doesn't seem to fit what I need, or cannot find the data required.
Hope this make sense and also hope you guys can help.
Look forward to hearing from you.
KR
Creaky
