Could Someone Tell me whats wrong with this

[jaedfamly]

Hello I have the following formula

=IF(ISNA(VLOOKUP(C6,'Medicare Crossover Directory'!A1:G14401,7,FALSE)),"Send David This Alpha Please",VLOOKUP(C6,'Medicare Crossover Directory'!A2:G9370,7,FALSE))


The issue I am having is that the alpha are not in abc order on the medicare crossover directory. I need it to read every row no matter what order. Is there an easier way to make this happen.


Thanks

[JBeaucaire]

This can possibly shortened to:

=IFERROR(VLOOKUP(C6,'Medicare Crossover Directory'!A1:G14401,7,FALSE)),"Send David This Alpha Please"))

VLOOKUP does not need the date sorted when you are using FALSE in the 4th parameter.