VLOOKUP? INDEX MATCH? invoice amounts from sheet 1 into sheet 2 based on a matching #
I'm looking for the invoice amounts from one sheet transfer into another sheet based on a matching CAR#.
For example: if CAR# FP2020-1 is listed in spreadsheet (B) then I want the invoice amount associated to populate into the $spent column in (A). I'm running into confusion because I can't figure out how to do this with spreadsheet (B) listing multiple of the same CAR#.
Any advise? (Paul are you out there?) 😆
Help Article Resources
Check out the Formula Handbook template!