Need VLOOKUP to pull duplicate values in a specific order
I'm importing an Excel sheet into Smartsheet every week and then using a VLOOKUP to pull the most recent balance amount for PO numbers in a sheet. For some POs there is the same reference number but the PO amount is split amongst different projects and therefore the balance for those rows should be different (see yellow highlighted rows).
I'm interested in knowing if I can pull in the balance value in the same row order as the imported sheet. It's currently recognizing the PO amount is different for the same reference number but it's pulling the same balance for both rows
It should have $2856.74 for the first row and then $6070.55 for the second row (both reference PO# 223044). Is there a way to do this?
Help Article Resources
Check out the Formula Handbook template!