Thread: formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default formula

Hi,

The formula is doing exactly what your telling it to do. Whether that's what
you want is another matter.

It's lookung at A27 of the sheet the formula is on for a lookup value and P1
of the same sheet for a column and P1 must be 1,2 or 3. It's then looking up
those values in sheet "Tuesday" and doing 1 of 3 things

1. No match for a27 = #N/A
2. Match for a27 on no corresponding data "DNP"
3. Match for a27 and corresponding data it returns the data

Could you explain a bit more clearly what you expect it to do?

Mike

"dwalston" wrote:

I wa wondering if you can help with this formula
=IF(VLOOKUP(A27,TUESDAY!$A$5:$AC$135,$P$1,FALSE)=" ","DNP",(VLOOKUP(A27,TUESDAY!$A$5:$AC$135,$P$1,FAL SE)))

I want it to give the total or if blank to fill in DNP. I appreciate your
help.

Thank you