I have two spreadsheets where I have a match on a partial text string with another text string in column A of each spreadsheet, where a match exists.
I need to lookup in the following 9 columns (B to J) in the same row as the match in each case a existing number and multiply it by the corresponding cell in the other spreadsheet where the match in column A occurs in each and every case.
Is there an if(vlookup( function that will deal with this where a match is found having said the text string is only partial?
I need to lookup in the following 9 columns (B to J) in the same row as the match in each case a existing number and multiply it by the corresponding cell in the other spreadsheet where the match in column A occurs in each and every case.
Is there an if(vlookup( function that will deal with this where a match is found having said the text string is only partial?