Hi
I have a spreadsheet with the following formula;
=VLOOKUP($C$2&$C28,'[SalesDatabase2006.xls]2006'!$A$5:$AX$5000,F$26,FALSE)
Where $C$2&$C28 is a concatenation of two cells, both cells being formula's (eg C2 is "BPA" C28 is "Consultancy")
$A$5:$AX$5000 is on a large spreadsheet (35mb) and is a concatenated text result, that is supposed to match the concatenation above.
F$26 contains a "column number" for the lookup to use.
I am getting loads of #N/A error messages and I am assuming that Excel is having difficulty matching the 2 concatenations. I have checked that they match, and on the face of it they do, but there is obviously a problem.
Unfortunately I inherited this spreadsheet...........can anyone suggest a better way of getting this lookup to work properly?
Thanks
I have a spreadsheet with the following formula;
=VLOOKUP($C$2&$C28,'[SalesDatabase2006.xls]2006'!$A$5:$AX$5000,F$26,FALSE)
Where $C$2&$C28 is a concatenation of two cells, both cells being formula's (eg C2 is "BPA" C28 is "Consultancy")
$A$5:$AX$5000 is on a large spreadsheet (35mb) and is a concatenated text result, that is supposed to match the concatenation above.
F$26 contains a "column number" for the lookup to use.
I am getting loads of #N/A error messages and I am assuming that Excel is having difficulty matching the 2 concatenations. I have checked that they match, and on the face of it they do, but there is obviously a problem.
Unfortunately I inherited this spreadsheet...........can anyone suggest a better way of getting this lookup to work properly?
Thanks