Vlookup and if statement combined

[UMAKEMESIK]

Hello to all,

I am new to the if statement and vlookup world and have been using
A very simple if statement with great results

=if(d22=0,(0),(c22))

Yes, simple but I like what it does and look to expand.

I have a wb with a number of sheets.
I want to place an if /vlookup statement in the
First worksheet called – worksheet in cell i17
I want to search sheet4 called Protective.
Search column B from B7:b41 for the phrase Setup-Preassembly.
If the phrase is found then return the value from sheet 4 in column c of the same row
To Worksheet cell i17 – if the phrase is not found return to i17 a value of nothing, or blank (“”)
I tried to write something that I knew would not work but I had to start somewhere.

=if(isna(vlookup(Setup-Preassembly,sheet4!b7:b41,2,)),””,(c))

Please forgive the crudeness of my first attempt.

Any help would be much appreciated.

 

[DanteAmor]

Try this

=IFERROR(VLOOKUP("Setup-Preassembly",Sheet4!B7:C41,2,0),"")

 

[UMAKEMESIK]

worked great.

thanks for taking the time.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.