Forum Discussion
Vlookup with IF Statement - return yes if cell is filled
Hi all! I have a sheet which tracks a process with several stages. This contains a username in the first column, and then several columns where dates are populated when each stage of the proc...
Riny_van_Eekelen thanks for your reply.
I have simplified and added it here - hopefully it makes sense. It doesn't seem to be differentiating still between ones with values in that last column and ones without.
So it's the formula in G16 I'm trying to work out. Basically if all stages are completed then we will have results in, so that's how I need to determine the yes or no answer.
hmwepp1989 Perhaps I'm missing the purpose of your schedule, but perhaps this formula is what you need.
=IF(ISNUMBER(VLOOKUP(G8,'Raw Data'!A1:G19,7,FALSE)),"Yes","No")entered in the attached (revised) file. Though the hard-coded number 7 isn't very dynamic. If I were you, I would enter the relevant column index in a cell, as shown in the file I sent earlier.
- Thank you! That would have worked, had I not just realised I now have duplicate usernames in some of my raw data and so Vlookup is out of the window 😞