It's a small question with a simple answer, but it points to something bigger: most spreadsheet users don't realize how close they are to making their data work harder. The user asking about combining `=VLOOKUP` with text like "Php" or "sq. m." is not looking for a workaround. They're looking for a way to make their spreadsheets speak human. And that's exactly the right instinct.
The solution, as many commenters will tell you, is the ampersand operator or the `CONCATENATE` function. Instead of trying to force a formula to output two things at once, you simply join them. For example, `="Php "&VLOOKUP(A2, B:C, 2, FALSE)` or `=VLOOKUP(A2, B:C, 2, FALSE)&" sq. m."`. This isn't a hack. It's the natural evolution of understanding how formulas think, in pieces that you control and combine. The user already knows what they want to say. They just needed the grammar to say it.
What's encouraging here is that the question isn't about advanced scripting or macros. It's about the fundamental act of shaping output to fit context. That's the kind of thinking that separates people who use spreadsheets from people who command them. When you start appending units, prefixes, or even full sentences to your lookups, you're no longer just retrieving data. You're building a narrative. You're turning a raw value into something meaningful for a client, a manager, or your own future self.
So if this question feels small, don't dismiss it. It's the first step toward a more fluid, more expressive way of working with data. The next time you need a result that says "Php 12,500" instead of just "12500," you won't search for a special function. You'll simply reach for the ampersand and move on. That's the quiet transformation we should all be aiming for, not flashy, not revolutionary, just a little more control over what your spreadsheet says and how it says it.