Forum Discussion
jhsilva808
Apr 29, 2020Copper Contributor
Correct Function? Want to VLOOKUP an equation in a cell for fertilizer calculator
Hello, hope all is well! I am creating a fertilizer calculator in excel. I am searching for a function or technique to help me do the following: I want to be able to VLOOKUP (or another functio...
wumolad
Apr 29, 2020Iron Contributor
Hi jhsilva808
I couldnn't follow your explanation, it appears some information needs to be better clarified.
You wanted formula in cells E19 to E35 that will relate with the soil types? What do you plan to use as the driver for this formula e.g. Is there a specific characteristic of each soil type that is in a table and you need the records relating to this specific information?
Also for the soil pH values, how do you determine which pH value is for which soil type?
I suggest you reformat the data, so it aligns with the relationship among the inputs.