Forum Discussion

KATHYSHOWARD's avatar
KATHYSHOWARD
Copper Contributor
Jul 28, 2021
Solved

Excel formula help

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 anothe...
Formulas and Functions
  • DKoontz's avatar
    DKoontz
    Jul 29, 2021
    Hi Kathy,
    =+VLOOKUP(B4,UNPAID!A:G,7,FALSE) in your gray box in C4 will work!
DKoontz's avatar
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!