Forum Discussion
Need to Pull More Numbers (VLOOKUP, INDEX, etc. not working)
SOLVED: I found a way to get the VLOOKUP to work properly (and not return an error) by nesting TEXT within; thus, I was able to ditch the FILTER function for column D! So I previously received som...
Again, I advise you to use a pivot table.
And do not copy the exported data from your third party software but use Power Query to import and manipulate the data.
The formula in column D does NOT refer to an invoice number - only to the start date and end date.
I am currently working within the parameters I was given for the project, and I was specifically asked to get a workbook up and running in which the manager could export, copy and paste. Until I am able to work outside of the current parameters, the exported data is the only way I can follow the contract of the project.
As for the formula not referencing the invoice number, I tried to find a way to have it reference and that is what I am struggling with. If you have an answer as to how to get that to reference properly all the material it needs to, then I would love to hear it.
As for the formula not referencing the invoice number, I tried to find a way to have it reference and that is what I am struggling with. If you have an answer as to how to get that to reference properly all the material it needs to, then I would love to hear it.
In the attached file i've entered FILTER formulas in cells A7 and D7. The results for the invoice amounts have a difference of 514,50 which is from the LAST EXP sheet ordered 11.02.2022 by Vendor 2.
- Hello! This worked nicely for a few of the rows. Luckily I do not need the order from the 11th. However, I may not have been as precise as I could have in my original post - I need the total from the LAST EXP sheet to show based on how it matches up with both the date and PO #, regardless if the amount is equal to that in column C.
I see now that the attachment on my original post was not the help file that had the PO #s entered.
Here is the help file with PO#s: https://1drv.ms/x/s!AjrdN6E65dMegYZ9sFnWpGFGyIi4lw?e=Btlr1D
I'm not married to the use of the formula currently sitting in there, if there is a better option!
