PDA

View Full Version : Solved: Cell format problem



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.

mdmackillop
12-05-2006, 03:42 PM
The Right function gives you text, not a number. Use either
=--RIGHT(C4,4) or =RIGHT(C4,4)*1
to force a numeric result.

Barryj
12-05-2006, 11:43 PM
Thanks MD, thats solved my problem.