Hlookup getting confused

O

Osvaldo

I have set a simple formula by using HLOOKUP.

The formula has to find a number, if found .. it has to display the
description of that code.

I have no problems with numbers like 1000.1 1000.2 , however when if
entered 1003.1. and
1003.11 problems emerge.

I typed 1003.11 and the description that is shown belongs to 1003.11.

What I am doing incorrectly ?

Tks in advance for any help. Tks for your time

Os.
 
N

Niek Otten

Hi Os,

<I typed 1003.11 and the description that is shown belongs to 1003.11.> Shouldn't it?

What is your formula?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have set a simple formula by using HLOOKUP.
|
| The formula has to find a number, if found .. it has to display the
| description of that code.
|
| I have no problems with numbers like 1000.1 1000.2 , however when if
| entered 1003.1. and
| 1003.11 problems emerge.
|
| I typed 1003.11 and the description that is shown belongs to 1003.11.
|
| What I am doing incorrectly ?
|
| Tks in advance for any help. Tks for your time
|
| Os.
|
 
O

Osvaldo

Hi Niek, tks for your answer

1) I incurred in a mistake when posting.

My sentence should read as follows:

// I typed 1003.11 and the description that is shown belongs to
1003.1 //


2) The formula is

=HLOOKUP(A7,$D$4:$Z$5,2)

Os.
 
N

Niek Otten

Hi Os,

You omitted the 4th argument to HLOOKUP. So it will use the default value, TRUE. This is from HELP:

<If HLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than lookup_value.>

If you need an exact match, use FALSE as the 4th argument (the table has to de sorted ascending then). If not, you may suffer from
rounding errors.
Post again in this thread if you have problems sorting it out.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Niek, tks for your answer
|
| 1) I incurred in a mistake when posting.
|
| My sentence should read as follows:
|
| // I typed 1003.11 and the description that is shown belongs to
| 1003.1 //
|
|
| 2) The formula is
|
| =HLOOKUP(A7,$D$4:$Z$5,2)
|
| Os.
|
| > Hi Os,
| >
| > <I typed 1003.11 and the description that is shown belongs to 1003.11.> Shouldn't it?
| >
| > What is your formula?
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
simple formula by using HLOOKUP.
| > |
| > | The formula has to find a number, if found .. it has to display the
| > | description of that code.
| > |
| > | I have no problems with numbers like 1000.1 1000.2 , however when if
| > | entered 1003.1. and
| > | 1003.11 problems emerge.
| > |
| > | I typed 1003.11 and the description that is shown belongs to 1003.11.
| > |
| > | What I am doing incorrectly ?
| > |
| > | Tks in advance for any help. Tks for your time
| > |
| > | Os.
| > |
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top