Forum Discussion
VLOOK & IF
I am trying to pull data from one tab onto a "Master" front page. I have tried VLOOKUP with IF as I am trying to get it to say true or false depending if the word complete in the in source column. P...
The simplest way to do that doesn't require IF or VLOOKUP.. This formula, copied down in subsequent rows, does the trick.
=(Sheet2!E2="Complete")
That formula returns TRUE if the referenced cell contains "Complete" and FALSE if it doesn't.
If you wanted something else to be returned, then you'd have to specify those other possible results in an IF statement, and maybe use VLOOKUP. No need, however, to make it more complicated if this is all you want.
That is perfect - thank you so much. This has been driving me bonkers 🙂