| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Troubleshooting Spreadsheets | Excel Discussion (Misc queries) | |||
| Troubleshooting my IF formula | Excel Discussion (Misc queries) | |||
| SUMPRODUCT troubleshooting | Excel Worksheet Functions | |||
| troubleshooting | Setting up and Configuration of Excel | |||
| Template troubleshooting... | Setting up and Configuration of Excel | |||
Linear Mode
