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.

Hi Kathy,=+VLOOKUP(B4,UNPAID!A:G,7,FALSE) in your gray box in C4 will work!

Excel formula help | Microsoft Community Hub

DKoontz
Steel Contributor
Jul 28, 2021
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!
NikolinoDE
Platinum Contributor
Jul 28, 2021
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)
- KATHYSHOWARD
  Copper Contributor
  Jul 28, 2021
  Windows 10 Pro
  Microsoft Office Standard 2019
  - NikolinoDE
    Platinum Contributor
    Jul 28, 2021
    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)