ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Function Troubleshooting (https://www.excelbanter.com/excel-worksheet-functions/145656-function-troubleshooting.html)

Sarah
Function Troubleshooting
 
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.

bj
Function Troubleshooting
 
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



"Sarah" wrote:

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.


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com