Det er ikke helt riktig! Excel's lookup functions, like VLOOKUP, HLOOKUP, and XLOOKUP, can definitely handle text (letters) as well as numbers .

Here's why you might be encountering an issue:

* Sakfølsomhet: Excel lookup functions are generally case-sensitive. If you're searching for "Apple" but your lookup table has "apple", it won't find a match. You can use the `EXACT` function to perform case-insensitive comparisons.

* Formatting Differences: Selv om teksten virker den samme, kan forskjellige formatering (f.eks. Ledende eller etterfølgende rom, fet tekst, forskjellige skrifter) føre til at oppslagsfunksjoner går glipp av en kamp. Ensure the data in your lookup table and the search value have consistent formatting.

* Typos: Simple typos can also throw off your lookup functions. Double-check your data for errors.

* Incorrect Function Usage: Make sure you're using the correct function for your needs. If you want to find an exact match, use `VLOOKUP` or `XLOOKUP` with the `range_lookup` argument set to `FALSE`. For approximate matches, use `VLOOKUP` with `range_lookup` set to `TRUE` (the default).

* Data Type Mismatches: Excel treats numbers and text differently. Ensure the lookup value and the data in the table are of the same data type.

Eksempel:

Let's say you have a lookup table:

| Frukt | Pris |

| --- | --- |

| Apple | $ 1 |

| Banan | $ 0,50 |

| Oransje | $ 0,75 |

You can use `VLOOKUP` to find the price of an "Apple":

`` Excel

=VLOOKUP("Apple", A1:B3, 2, FALSE)

`` `

This formula will return `$1`.

To troubleshoot your specific problem:

1. Share your formula: Provide the exact formula you are using and the data in your lookup table.

2. Describe your expected outcome: What result are you hoping to achieve?

I can help you figure out why your lookup is not working correctly.