SOLVED

Excel formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2594343%22%20slang%3D%22en-US%22%3EExcel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594343%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20create%20a%20spreadsheet%20pulling%20information%20from%20one%20spreadsheet%20into%20another.%20I%20want%20to%20input%20a%20bill%20%23%20on%20one%20spreadsheet%20and%20have%20it%20pull%20the%20corresponding%20amount%20for%20that%20bill%20%23%20from%20another%20spreadsheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2594343%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-2596129%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2596129%22%20slang%3D%22en-US%22%3EOH!%20MY!%20GOODNESS!%20Thank%20you%20so%2C%20so%20much!%20That%20worked%20perfectly.%20I%20was%20so%20close%20but%20just%20couldn't%20figure%20out%20what%20I%20was%20doing%20wrong.%20I%20appreciate%20you%20help!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2595487%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595487%22%20slang%3D%22en-US%22%3EHi%20Kathy%2C%3CBR%20%2F%3E%3D%2BVLOOKUP(B4%2CUNPAID!A%3AG%2C7%2CFALSE)%20in%20your%20gray%20box%20in%20C4%20will%20work!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2595262%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595262%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3BThis%20may%20be%20a%20duplicate.%20I%20responded%20this%20morning%20but%20don't%20see%20that%20response%20now.%26nbsp%3B%20I%20apologize%20if%20this%20is%20a%20duplicate%20message.%26nbsp%3B%20I%20am%20trying%20to%20input%20a%20bill%20%23%20on%20the%20Tax%20Sale%20spreadsheet%20and%20have%20the%20formula%20search%20that%20bill%20%23%20in%20the%20Unpaid%20spreadsheet%20and%20pull%20the%20corresponding%20bill%20amount%20from%20column%20G%20into%20the%20Tax%20Sale%20sheet%20in%20the%20amount%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594732%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594732%22%20slang%3D%22en-US%22%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%20Even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%20This%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594373%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594373%22%20slang%3D%22en-US%22%3EWindows%2010%20Pro%3CBR%20%2F%3EMicrosoft%20Office%20Standard%202019%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594368%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594368%22%20slang%3D%22en-US%22%3EYou%20can%20accomplish%20this%20using%20an%20xlookup%20or%20if%20you%20have%20an%20older%20version%20of%20excel%2C%20vlookup.%20Without%20knowing%20specifics%20it's%20hard%20to%20say%20exactly%20but%20if%20you%20do%20some%20research%20on%20these%20functions%20it%20will%20accomplish%20what%20you're%20looking%20for!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594361%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594361%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1114785%22%20target%3D%22_blank%22%3E%40KATHYSHOWARD%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20please%20read%20the%20informations%20in%20the%20Link%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need to create a spreadsheet pulling information from one spreadsheet into another. I want to input a bill # on one spreadsheet and have it pull the corresponding amount for that bill # from another spreadsheet.

7 Replies

@KATHYSHOWARD 

If you’re looking to ask a question please read the informations in the Link

Welcome to your Excel discussion space!

 

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

You can accomplish this using an xlookup or if you have an older version of excel, vlookup. Without knowing specifics it's hard to say exactly but if you do some research on these functions it will accomplish what you're looking for!
Windows 10 Pro
Microsoft Office Standard 2019
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.


Thank you for your understanding and patience

Nikolino
I know I don't know anything (Socrates)

@NikolinoDE This may be a duplicate. I responded this morning but don't see that response now.  I apologize if this is a duplicate message.  I am trying to input a bill # on the Tax Sale spreadsheet and have the formula search that bill # in the Unpaid spreadsheet and pull the corresponding bill amount from column G into the Tax Sale sheet in the amount column.

best response confirmed by KATHYSHOWARD (New Contributor)
Solution
Hi Kathy,
=+VLOOKUP(B4,UNPAID!A:G,7,FALSE) in your gray box in C4 will work!
OH! MY! GOODNESS! Thank you so, so much! That worked perfectly. I was so close but just couldn't figure out what I was doing wrong. I appreciate you help!!