Correct Function? Want to VLOOKUP an equation in a cell for fertilizer calculator

%3CLINGO-SUB%20id%3D%22lingo-sub-1348556%22%20slang%3D%22en-US%22%3ECorrect%20Function%3F%20Want%20to%20VLOOKUP%20an%20equation%20in%20a%20cell%20for%20fertilizer%20calculator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1348556%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20hope%20all%20is%20well!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20fertilizer%20calculator%20in%20excel.%26nbsp%3B%20I%20am%20searching%20for%20a%20function%20or%20technique%20to%20help%20me%20do%20the%20following%3A%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20to%20VLOOKUP%20(or%20another%20function)%20specific%20equations%20(cells%20E19-E35%3B%20example%20in%20D13)%20unique%20to%20various%20soil%20types%20(cells%20A19-A35)%2C%20and%20have%20another%20function%20that%20will%20input%20soil%20pH%20values%20(either%20cells%20K%2C%20L%2C%20M17-35)%20specific%20to%20certain%20crops%20(cells%20J17-35)%20in%20place%20of%20%22X%22%20in%20the%20equation.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20overall%20equation%20looks%20something%20like%20this%3A%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3EFertilizer%20amount%3D%20Function%20(pH%20of%20crop)%20-%20Function%20(pH%20measured)%2C%20where%20the%20Function%20is%20the%20equations%20from%20E19-E35%20(D13%20example%3A%20%5BLN(X-7.7)%2F(-0.85)%5D%2F(-0.98)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jhsilva808_2-1588211177443.png%22%20style%3D%22width%3A%20739px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F187743i676D4EEB051B0468%2Fimage-dimensions%2F739x402%3Fv%3D1.0%22%20width%3D%22739%22%20height%3D%22402%22%20title%3D%22jhsilva808_2-1588211177443.png%22%20alt%3D%22jhsilva808_2-1588211177443.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20appreciate%20any%20help%20or%20advice%20one%20can%20offer.%26nbsp%3B%20Thank%20you%20and%20take%20care!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1348556%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1348652%22%20slang%3D%22en-US%22%3ERe%3A%20Correct%20Function%3F%20Want%20to%20VLOOKUP%20an%20equation%20in%20a%20cell%20for%20fertilizer%20calculator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1348652%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F642246%22%20target%3D%22_blank%22%3E%40jhsilva808%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20couldnn't%20follow%20your%20explanation%2C%20it%20appears%20some%20information%20needs%20to%20be%20better%20clarified.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20wanted%20formula%20in%20cells%20E19%20to%20E35%20that%20will%20relate%20with%20the%20soil%20types%3F%20What%20do%20you%20plan%20to%20use%20as%20the%20driver%20for%20this%20formula%20e.g.%20Is%20there%20a%20specific%20characteristic%20of%20each%20soil%20type%20that%20is%20in%20a%20table%20and%20you%20need%20the%20records%20relating%20to%20this%20specific%20information%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20for%20the%20soil%20pH%20values%2C%20how%20do%20you%20determine%20which%20pH%20value%20is%20for%20which%20soil%20type%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suggest%20you%20reformat%20the%20data%2C%20so%20it%20aligns%20with%20the%20relationship%20among%20the%20inputs.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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 function) specific equations (cells E19-E35; example in D13) unique to various soil types (cells A19-A35), and have another function that will input soil pH values (either cells K, L, M17-35) specific to certain crops (cells J17-35) in place of "X" in the equation. 

 

The overall equation looks something like this:  
Fertilizer amount= Function (pH of crop) - Function (pH measured), where the Function is the equations from E19-E35 (D13 example: [LN(X-7.7)/(-0.85)]/(-0.98)

jhsilva808_2-1588211177443.png

 

I appreciate any help or advice one can offer.  Thank you and take care!

1 Reply
Highlighted

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.