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...
This is very helpful. Though in mine I do not have a stage input, so I would effectively like to lookup based on a certain column in the raw data.
So say if date is in column P for this username return yes, if not return no. I suppose I could add the stage but that would also have to pull from the other sheet and would need another formula to determine what stage it's at depending on which column has been filled in.
So say if date is in column P for this username return yes, if not return no. I suppose I could add the stage but that would also have to pull from the other sheet and would need another formula to determine what stage it's at depending on which column has been filled in.
Just to add - I know this is wrong but it's the thing I thought would be along the right lines:
=if(VLOOKUP(G8,'raw data'!A1:P20500,16,FALSE),ISBLANK('raw data'!P:P),"No","Yes")
=if(VLOOKUP(G8,'raw data'!A1:P20500,16,FALSE),ISBLANK('raw data'!P:P),"No","Yes")