Forum Discussion
Indes Match fails when using 2 worksheets in same workbook
Thank you very much for your rapid response.
Sadly, the solution still fails. At least I now get data "transferred" - i.e. no error messages BUT the data is totally incorrect for all columns to the right of Column B into which I carefully typed your formula but then changed the INDEX location to columns C,D, E, etc.
The data simply does not match what should be showing on LINE 19.
If I fill down the problem is even more perplexing because it ALWAYS returns the same values as in Line 19 despite changing making the match value relative to the line.
The data source tab (Combined) has multiple lines related to HSBC but with different dates, account numbers, account groups, description, etc. and the formula is pulling data incorrectly.
Again, I can supply a sample workbook if required to assist troubleshooting
DeWayne Bruce You can share the file via Onedrive or something similar.
- Excellent response that pointed me to my basic error.
The ongoing issue of incrrect data transfer has been overcome by giving each transaction a unique transaction number.
The only issue now is how to stop an empty cell on Combined from displaying zero on the transfer page (e.g. HSBC)
Thanks very much for your professional assistance! Well doneDeWayne Bruce Glad you worked it out. To avoid blanks to return zero, try wrapping the entire formula in an IF statement that starts by checking the content of the referenced cell.
Something like:
=IF( cell="","", the INDEX/MATCH formula )