Posted to microsoft.public.excel.worksheet.functions

dwalston

external usenet poster

Posts: 3

if v lookup formula

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup formula	rldjda	Excel Worksheet Functions	3	March 16th 08 11:20 PM
LOOKUP Formula	Kimo	Excel Worksheet Functions	15	July 26th 07 04:09 AM
Lookup formula help	jillteresa	Excel Worksheet Functions	4	August 1st 06 05:22 PM
Max Lookup formula	sam	Excel Worksheet Functions	5	September 16th 05 06:55 AM
Lookup Formula - but have a formula if it can't find/match a value	Stephen	Excel Worksheet Functions	11	June 14th 05 05:32 AM

All times are GMT +1. The time now is 01:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us