How do I search a range for dates some ceels of which may be empty

G

Guest

Which function can I ues to search a spreadsheet range, some cells of which
may be empty, to return dates entered in the spreadhsheet? I have tried
VLOOKUP, HLLOKUP, MATCH and DGET but they do not like empty cells.
 
G

Guest

Hi
they should no cause a problem.
what are the exact formulas you have tried
- what is your expected result
 

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 ignoring empty cells 6
lookup function?? 2
Counting Results of Formulas 1
help with Blank Dates in a Range 1
VLOOKUP and DGET to find a value with multiple criterion 8
VLOOKUP worksheet function returns zero for empty cells 3
First row where a cell is zero 1
Vlookup with variable column reference 1

Top