Hello
I have a spreadsheet with which I've got a VLOOKUP. I'd like this to work so that that it also returns the first row first but then each subsequent row where the word No appears in column E.
I've used =IF(E2="No",C2,"") but with this however it leaves big blanks in my data making it untidy. I'd like each row to be populated.
Can anyone help?
Thanks
Bookmarks