Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2974949%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2974949%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20items%20and%20corresponding%20prices.%26nbsp%3B%20On%20a%20different%20spreadsheet%20within%20the%20same%20workbook%2C%20I%20want%20to%20be%20able%20to%20enter%20an%20item%20in%20one%20cell%20and%20have%20the%20corresponding%20price%20automatically%20enter%20in%20another%20cell%20on%20the%20same%20spreadsheet.%26nbsp%3B%20How%20do%20I%20do%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2974949%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2975128%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2975128%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F163429%22%20target%3D%22_blank%22%3E%40Lisa%20LaCombe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20may%20provide%20small%20sample%20file%3F%20It'll%20be%20much%20easier%20to%20illustrate%20formulae%20on%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2974996%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2974996%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F163429%22%20target%3D%22_blank%22%3E%40Lisa%20LaCombe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20any%20of%20lookup%20functions%20-%20VLOOKUP%2C%20INDEX%2FMATCH%2C%20XLOOKUP%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a spreadsheet with items and corresponding prices.  On a different spreadsheet within the same workbook, I want to be able to enter an item in one cell and have the corresponding price automatically enter in another cell on the same spreadsheet.  How do I do that?

6 Replies

@Lisa LaCombe 

You may use any of lookup functions - VLOOKUP, INDEX/MATCH, XLOOKUP

I am not experienced with using these functions. How can I learn which will work the best for my situation?

@Lisa LaCombe 

Perhaps you may provide small sample file? It'll be much easier to illustrate formulae on it.

@Sergei Baklan 

I want to take the ($Value) column numbers from the items spreadsheet and have them autofill to the Donation spreadsheet.  I know I will need a dropdown in the on the Donations spreadsheet and then based on what is selected, I want the corresponding ($Value) to autogenerate on the Donations page.  Hopefully, I am explaining myself clearly.

 

@Lisa LaCombe 

Thank you. If "General Description of Discarded Item" has same values as "New Household Item", that could be like

=XLOOKUP( ref on General Description Item, Column with New Tems, Column with Values)
e.g.

=XLOOKUP( A2, 'Items'!$A$2:$A$10, 'Items'!$H$2:$H$10 )
Thank you. I will try that.