Function Troubleshooting

S

Sarah

I have the following instance:

Cells C8:C12 which I am having issues with and columns AE:AI which contain
my information :
in C8 I have used validation to create a dropdown list of names
in C9 I have the following formula:
=IF(C8="","",IF(ISNA(VLOOKUP(C8,timecard,2,0)),"No
Match",VLOOKUP(C8,timecard,2,0)))

Once I get to a certain point in column AE (specifically row 99) I get "No
Match" for my function answer.

Please advise.
 
B

bj

I assume that you have the timecard as columns AE:AI
how is timecard defined
what happens when you use the equation =c8=AE99 when C8 looks like it
matched AE99
it may not be a match
 
Top