Hi all
I am pulling data from multiple tabs to provide sales information for each week on a collated tab.
I am using the VLOOKUP formula to pull the sales from each tab.
I then was using the IFERROR function to remove the annoying #N/A that is being thrown on quite a lot.
=IFERROR(VLOOKUP(A2,'2023.01.09'!$A$2:C3644,3,FALSE),IF(B2="",""))
When using the above it did give me the circular referees warning message - not sure why.
This worked well, however when I then came to SUM together rows, if the row had a IFERROR in it it would stop all the data from summing.
What is the best formula to use with VLOOKUP to pull data but to not get bogged down with the #N/A's. Prefereably the #N/A's would either be a zero or blank (and capable of being used in a SUM).
Thanks
I am pulling data from multiple tabs to provide sales information for each week on a collated tab.
I am using the VLOOKUP formula to pull the sales from each tab.
I then was using the IFERROR function to remove the annoying #N/A that is being thrown on quite a lot.
=IFERROR(VLOOKUP(A2,'2023.01.09'!$A$2:C3644,3,FALSE),IF(B2="",""))
When using the above it did give me the circular referees warning message - not sure why.
This worked well, however when I then came to SUM together rows, if the row had a IFERROR in it it would stop all the data from summing.
What is the best formula to use with VLOOKUP to pull data but to not get bogged down with the #N/A's. Prefereably the #N/A's would either be a zero or blank (and capable of being used in a SUM).
Thanks