Posted to microsoft.public.excel.worksheet.functions
|
|
if v lookup formula
Hi
when I put a number in the cell it is still putting the DNP on sheet in
stead of the number that is in the cell I only want the DNP when there is
nothing in the cell
Thank you for the help
"Max" wrote:
.. if there is nothing in the cell ..
I presume you are referring to the vlookup's return? Don't see anything
wrong with your formula per se. It could be a case of a white space throwing
expected returns off (the white space in the cell will look like the
"nothing"). You could try wrapping a TRIM around the vlookup, like this:
=IF(TRIM(VLOOKUP(A26,Tuesday!$A$5:$AC$124,$P$1,FAL SE))="","DNP",TRIM(VLOOKUP(A26,Tuesday!$A$5:$AC$12 4,$P$1,FALSE)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dwalston" wrote:
I have this formula
=IF(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FALSE)=" ","DNP",(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FAL SE)))
What I would like this to do is if there is nothing in the cell it should
put DNP and if there is the numbers 0,1,2,3,4 I want it to put those numbers
in the cell. Can you help me
Thank you Dwalston
|