VLOOK & IF

%3CLINGO-SUB%20id%3D%22lingo-sub-2270311%22%20slang%3D%22en-US%22%3EVLOOK%20%26amp%3B%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2270311%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20pull%20data%20from%20one%20tab%20onto%20a%20%22Master%22%20front%20page.%3C%2FP%3E%3CP%3EI%20have%20tried%20VLOOKUP%20with%20IF%20as%20I%20am%20trying%20to%20get%20it%20to%20say%20true%20or%20false%20depending%20if%20the%20word%20complete%20in%20the%20in%20source%20column.%20Please%20help%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2270311%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2270495%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOK%20%26amp%3B%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2270495%22%20slang%3D%22en-US%22%3EIt%20would%20be%20a%20lot%20easier%20to%20help%20if%20you%20gave%20us%20a%20sample%20of%20the%20actual%20Excel%20workbook.%20If%20the%20actual%20one%20contains%20confidential%20information%2C%20then%20create%20a%20mockup%20without%20that%20real%20info.%20Also%20let%20us%20know%20what%20version%20of%20Excel%20you're%20working%20with.%3CBR%20%2F%3EYour%20original%20question%20raises%20more%20questions%20as%20well.%20Are%20you%20actually%20trying%20to%20pull%20data%2C%20or%20just%20get%20a%20%22true%22%20or%20%22false%22%20--%20you%20say%20both%20things.%20Or%20is%20it%2C%20IF%20x%20is%20true%2C%20then%20do%20the%20pulling%20of%20data.%20You%20see%2C%20I%20hope%2C%20the%20ambiguity%2C%20and%20why%20it%20might%20be%20difficult%20to%20offer%20the%20correct%20solution.%3C%2FLINGO-BODY%3E
New Contributor

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. Please help 

7 Replies
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.

@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.

@Claire_W1825 

 

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

@mathetes I have another issue now sorry - I am trying to match data from a third tab but the data is in a different order / might not be there.

I need to return true/false again assuming the data in Column C tab three matches Column C tab 1 and that Tab Three Colum F says complete.

If there is no match to column C tabs 1 & 3 I need it to show Error.

 

@Claire_W1825 

 

This isn't quite what you requested, but let me suggest it instead. It's a bit more precise, showing the status if the name is found, and "Error" if the name is NOT found. But it shows status rather than showing "True" only if name and "completed".

 

=IFERROR(INDEX(Sheet3!$F$2:$F$10,MATCH(Mastersheet!C2,Sheet3!$D$2:$D$10,0)),"ERROR")

 

 

@Claire_W1825 

As a comment

- you have Mastersheet, Sheet2 and Sheet3, but no tab 1 and tab 3 worksheets

- assuming they are in sequential order, Column C in Mastersheet is Client, and Column C in Sheet2 is Due Date - these fields never matches

- assuming we match clients, not dates, desired result is true/false and Error, i.e. three results are required where only two is possible, when matches or not.

@mathetes makes some assumptions, with my ones as variant it could be

 

=NOT(ISNA(MATCH(C2&"Complete",Sheet3!D:D&Sheet3!F:F,0)))