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...
It would be a lot easier to help if you gave us a sample of the actual Excel workbook. If the actual one contains confidential information, then create a mockup without that real info. Also let us know what version of Excel you're working with.
Your original question raises more questions as well. Are you actually trying to pull data, or just get a "true" or "false" -- you say both things. Or is it, IF x is true, then do the pulling of data. You see, I hope, the ambiguity, and why it might be difficult to offer the correct solution.
Your original question raises more questions as well. Are you actually trying to pull data, or just get a "true" or "false" -- you say both things. Or is it, IF x is true, then do the pulling of data. You see, I hope, the ambiguity, and why it might be difficult to offer the correct solution.
mathetes thank you - I have added a Test one as the main file I am working on contains client data.
I am basically looking to return True or False in Column D on the master page, if the word "Complete" appears on the second tab column E. Does that make more sense - sorry. I know what I want to achieve just not sure how to articulate it.