Skip to content
The Chat Archive
o3-2025-04-16· OpenAI LMArena Human Preference 140K

Can I use the output of the XLOOKUP function in Excel as a parameter within Cells? So,…

  1. User

    Can I use the output of the XLOOKUP function in Excel as a parameter within Cells? So, as an example:

    I'd like to have the output of XLOOKUP, which I expect to be a two digit number, appear after text. WIthin a cell, I'd like to have this format: "exampletext"[XLOOKUP output]

    Is this possible, or will I need to concat two cells together?

  2. Assistant

    Yes—just put everything in a single formula and concatenate the pieces.
    The rule is:

    • Anything inside double-quotes is treated as literal text.
    • Anything outside the quotes is treated as a calculation.
    • To join them together you use the concatenation operator (&) or one of the CONCAT / TEXTJOIN functions.

    Example with the & operator

    ="exampletext" & XLOOKUP(A2, lookup_array, return_array)
    

    If the XLOOKUP should always display two digits (e.g. 03 instead of 3) wrap it in TEXT:

    ="exampletext" & TEXT( XLOOKUP(A2, lookup_array, return_array), "00")
    

    That entire formula lives in a single cell—no helper cells required.

    Optional niceties

    =LET(
        found, XLOOKUP(A2, lookup_array, return_array, ""),   // "" prevents #N/A
        "exampletext" & TEXT(found, "00")
    )
    

    Bottom line: You can’t embed a formula inside the quotes, but you can concatenate the XLOOKUP result with the text so the final output appears exactly as you want in one cell.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.