Can we Use vlookup function with other functions like concat,if,ect

[satya kalyan]

we can use CONCATENATE and V lookup ...anything else can be use in the similar way ...with look up

 

[vasim]

In a few instances I use, Left Right along with Vlooup.

 

[Luke M]

In short, Yes. You can nest different functions (up to 7 nested layers pre-2007) in a single formula.