I recently exported two reports from Quickbooks Pro in CSV format. Text
strings in one report had surplus characters which I "removed" using text
functions. The resultant text using LEFT(no of characters) then matched text
strings in second report. The number of rows in the first report was about
twice those in second report. My aim was to obtain data in column 3 of the
second report by placing an Index and Match function in the first report
column 4. Whilst the first row worked, all subsequent rows produced the N#A
error. On evaluation the formula, the problem was no value in the array part
of the MATCH function. I suspect this might be something to do with CSV files
not being properly converted on opeing in Excel or that the computed text
string in report one cannot be used in a MATCH function yet the look up value
is correct. This is very frustrating as there are a lot of rows to deal with
(stock values)
Any help please....