How can i pull the latest budget number from one sheet into another sheet automatically?

olvin.vargas

I have a sheet in which i track revisions, for each revision a new row is added. I'm trying to pull data from this revisions sheet to another sheet but i want to pull only 4 data fields that reflect the latest numbers for the last revision. Is there a formula i can use?

AravindGP

Hi @olvin.vargas

You can use an INDEX/MAX formula if you have an auto number column capturing the row# of the new row. If there are no other parameters to fetch the value, you can use the formula reference below.

=INDEX({Column reference from sheet 1 which has the data you need}, MAX({Column reference from sheet 1 which has the auto number}

You can replace the column reference after INDEX with column 2 to capture the second data field, and so on