Hello Everyone,
Krish here. I am not fully conversant in the multitudes of Excel formulas and their combinations. I have managed to pick up usage of some formulas e.g. "IF", "Sumifs", basic VLookup and other basic stuff.
I have a table part of which I have attached. It is a table where farm fertilizer rates have to filled in the main table (Table 1) after scanning data from Table 2 (leaf analytical data) and from Table 3 that specifies the rates of fertilizer (TSP, HiK+, SOA, MOP, BOR, KIES, HiK++) based on the leaf nutrient values in Table 2.
The farm is a large farm divided into blocks (BLK). The blocks have been grouped (colour coded in Table 1) and from each group, 1 block has been selected for leaf sampling and analysis of nutrient content (N,P,K, Mg, B). The leaf analytical information from this block is assumed to represent the other blocks in the group.
What I would like to achieve is to quickly fill in the fertilizer rates in Table 1 without having to do it manually. So the formula will scan the BLK in Table 1, maybe match with BLK in Table 2, match nutrient in Table 2 with Table nutrient range, then pick out the fertilizer from the top of Table 1 matching with the fertiliser in Table 3 and return the corresponding fertilizer value shown for the nutrient ranges.
Once the fertilizer inputs for the leaf sampled block are inputted into the corresponding row in Table 1, then I can copy it for the other blocks in the group. Or there might be a formula to replicate it based on the color of the cells (maybe?).
I have tried Vlookup combined with Match and Index combined with Match but to no avail. Most times I get a "Value!" or "Ref!" return. Also, I gotten the "Too many arguments" scolding from Excel!
If anyone can guide me, I would be grateful. There is a total of about 350 blocks in leaves from the plants were analysed. Manually inputting fertilizer requirements will be tedious, as I have done in the past!!
Thank you and please keep safe.
Regards,
Krish
Krish here. I am not fully conversant in the multitudes of Excel formulas and their combinations. I have managed to pick up usage of some formulas e.g. "IF", "Sumifs", basic VLookup and other basic stuff.
I have a table part of which I have attached. It is a table where farm fertilizer rates have to filled in the main table (Table 1) after scanning data from Table 2 (leaf analytical data) and from Table 3 that specifies the rates of fertilizer (TSP, HiK+, SOA, MOP, BOR, KIES, HiK++) based on the leaf nutrient values in Table 2.
The farm is a large farm divided into blocks (BLK). The blocks have been grouped (colour coded in Table 1) and from each group, 1 block has been selected for leaf sampling and analysis of nutrient content (N,P,K, Mg, B). The leaf analytical information from this block is assumed to represent the other blocks in the group.
What I would like to achieve is to quickly fill in the fertilizer rates in Table 1 without having to do it manually. So the formula will scan the BLK in Table 1, maybe match with BLK in Table 2, match nutrient in Table 2 with Table nutrient range, then pick out the fertilizer from the top of Table 1 matching with the fertiliser in Table 3 and return the corresponding fertilizer value shown for the nutrient ranges.
Once the fertilizer inputs for the leaf sampled block are inputted into the corresponding row in Table 1, then I can copy it for the other blocks in the group. Or there might be a formula to replicate it based on the color of the cells (maybe?).
I have tried Vlookup combined with Match and Index combined with Match but to no avail. Most times I get a "Value!" or "Ref!" return. Also, I gotten the "Too many arguments" scolding from Excel!
If anyone can guide me, I would be grateful. There is a total of about 350 blocks in leaves from the plants were analysed. Manually inputting fertilizer requirements will be tedious, as I have done in the past!!
Thank you and please keep safe.
Regards,
Krish