Hey all,
I am working with a large dataset and want to use the IF formula in excel to reference a table of initial visit dates for clients for serial rows of following visits. Each row has the client ID and I want to use the IF formula to reference the client ID with the ID from the initial visit table, but it keeps returning FALSE when I know there is a initial visit for each client. Any suggestions?