formula

[dwalston]

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,FALSE)))

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

Thank you

 

[Mike H]

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