Vlookup

I am updating information on to a sheet when I contact our customers AP dept either by email or Phone. The info I update includes Invoice- date- AP response.

I want to use this data to link to another sheet that I am using to track open invoices via Vlookup.

When I populate the sheet I have been inserting rows on top so the Vlookup will work

Is there another formula I can use If I update the info on the last line of data instead of the first line?

Thanks

Find more posts tagged with

Finance

Formulas

Account and User Management

Comments

Daniel Stein

Hi Debbie,

When you create your VLOOKUP formula, I would recommend that you select the entire columns of your lookup table. In the "Reference Another Sheet" dialog, click on the header of the first column, then Shift+Click on the header of the last column. Selecting entire columns in this way rather than a range of cells will ensure that any new rows get automatically incorporated into the lookup table, regardless of where they are inserted.

Best regards,

Daniel

Debbie J

Hi Dan

I have that set

It is finding the most current comment which would be at the end of the row and and the first

So if a vlookup finds the first record from top to bottom im looking from bottom to top

On this log I can call AP on 1/5/18 and inquire about inv 456, 457 & 458 and then I can call on 3/15/18 on the same invoices and have the field update with the latest comments.

I don't know if there is a formula but I figured I would ask

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?