VLOOKUP

P

PAL

I am using vlookup with the following formula:

=VLOOKUP($A2,PROTOCOL,12,FALSE)

Column 12 is a date (01-jan-08). When the value in 12 is blank, I get
"0-jan-00" returned. How do I tweak to keep blank.

Thanks
 
G

Gord Dibben

=IF(VLOOKUP($A2,PROTOCOL,12,FALSE)="","",VLOOKUP($A2,PROTOCOL,12,FALSE))


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup doesn't work: results are wrong 2
Referring to a cell by using another cell for the row number 6
Can I add a formula or function to Vlookup? 1
HELP!!!!!!!!! 2
Use & with two formulas 2
blank cell return vs. a 0 8
Same forumula returns both 0 & N/A 2
VLookup Won't Copy down (#REF! error) 1

Top