Forum Discussion
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...
- Hi Kathy,
=+VLOOKUP(B4,UNPAID!A:G,7,FALSE) in your gray box in C4 will work!
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.
Hi Kathy,
=+VLOOKUP(B4,UNPAID!A:G,7,FALSE) in your gray box in C4 will work!
=+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!!