Combining If Formula with Vlookup (After successfully pulling in data through VLookup)

[marcellebuff]

Hi Mr. Excel Fam.,

Please advise:
How would I create a formula string that performs Vlookup to pull data from another cell, and combine it with a formula that continues with an If formula.

For example: =Vlookup(...)Then(If...,)

Really appreciate any input!

Thank you!

MK

 

[nmr4u]

On getting the Vlookup result, concatenate it with the if formula.

For example, =vlookup("a",a1:a10,1,false)&if(a1="a","+","-")