Share via

How to use VLOOKUP function for one column in Excel to get the approximate value text?

Anonymous
2022-11-10T06:59:29+00:00

Hello,

I was trying to use VLOOKUP functions to find the approximate value in one column but when I use it it gives me the unwanted value text, see the following picture to see the situation:

In the situation in this picture, it should gives me Fourteenth and not Fifteenth.

Also, see the situation:

in the situation in this picture it should gives me the value text of Seventeenth and not Fourteenth.

It seems it always gives me the value that is located above the approximate value.

Is there any solution for this problem?

The formula that I used in C5 is: =VLOOKUP(C1,A1:A5,1,TRUE)

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2022-11-10T07:57:23+00:00

    Hi there

    Please try the following

    1. In cell C1 type Sev*
    2. In cell C5 enter the formula

    =VLOOKUP(C1,A1:A5,1,FALSE)

    With the last argument set to FALSE

    I hope this helps you

    Regards

    Jeovany

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-11-10T11:24:07+00:00

    You are very welcome.

    I'm glad you found a solution to your problem

    Thanks for the positive feedback.

    Regards

    Jeovany

    0 comments
  2. Anonymous
    2022-11-10T08:25:59+00:00

    Hi, Jeovany

    Thank you so much for the help, I didn't know the problem is that I was no using star "*" but also, I thought instead of every time I type star "*" in the end of text in C1, why don't I include stare "*" inside the formula so the formula will look like this: =VLOOKUP(C1&"*",A1:A5,1,FALSE) but this when C1 is empty that seems will give me the value of the first cell that is not empty in the range which now in this case is Fifteenth, but that is not a problem for me now.

    Thank you so much.

    0 comments