Barryj
12-05-2006, 02:56 PM
in cell C4 I have 0230 9985 in cell D4 I have formula =RIGHT(C4,4) which gives me the number 9985.
In cell E4 I have a lookup & match formula for cell D4, but it comes up with a N/A in the column.
When I just put the number 9985 in cell D4 without the =RIGHT formula it works fine.
Is there a format issue when using a fomula to lookup the results of another formula.
In cell E4 I have a lookup & match formula for cell D4, but it comes up with a N/A in the column.
When I just put the number 9985 in cell D4 without the =RIGHT formula it works fine.
Is there a format issue when using a fomula to lookup the results of another formula.