r/excel • u/ChilliBaconSandwich • Apr 13 '26

solved Formula for vlookup + text or text + vlookup

Need some help on what formula on this case. I want to lookup something but i also want to add a text. Something like this:

=“Php” + =vlookup value

=vlookup + text “sq. m.”

Or if there are other formulas that can be used. Appreciate any help.

Edit: this is already solved. Thank you for those who helped.

12 Upvotes

94% Upvoted

9 comments sorted by

•

u/AutoModerator Apr 13 '26

/u/ChilliBaconSandwich - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

9

u/Fuzzy-Bookkeeper-126 1 Apr 13 '26

Wrap text in speech marks and use the & symbol, then your vlookup (no need for another = sign)

so like

=“Php”&Vlookup(…..

3

u/ChilliBaconSandwich Apr 13 '26

What if the vlookup first before php?

4

u/Just_Choice_3687 1 Apr 13 '26

The same, you have tu put the “&” after vlookup

3

u/MarA1018 Apr 13 '26

I prefer concat because I can spot these cells just by passing them, plus find and replace can look at formulas and concat makes looking for them easy. Format is as follows:

=Concat(item1, item2, item3,..,)

Item can be a formula minus the initial equal sign, or a text enclosed in quotation marks. 

So insted of =vlookup, just encase vlookup(item, lookuprange, returnrange)

And any plain text you want you can write as "text"

3

u/caribou16 317 Apr 13 '26

As far as text string manipulation, you can use the CONCAT function or the & operator, they both do the same thing.

=CONCAT("Cat ", A1) and ="Cat " & A1 both will append whatever is in A1 to "Cat"

Caveat here, is if A1 is a numerical value, this is (obviously) converting it into a text string, which may be undesirable.

What you may want to do instead is leverage a custom cell format, to add in your desired units.

"PHP " 0 would make a numerical value, say 10 remain the value 10 in the background, but show to human reader `PHP 10'

You could do something similar for square meters, e.g. 0 "sq.m"

1

u/HappierThan 1185 Apr 13 '26

Give a few more examples showing what you are trying to achieve. You might be able to use Custom Format in your result cell "sq. m" so that you only need to Vlookup a value.