HLOOKUP関数について

[Nao_saito]

以下のように数字を引数としても、正しく数値が表示されません。セルの書式設定ですべて文字列にしているのですが、うまくいきません。理由の分かる方いらっしゃったら教えていただけますと幸いです。

[#2]

@Nao_saito 

If range_lookup is FALSE and lookup_value is text, you can use the wildcard characters, question mark (?) and asterisk (*), in lookup_value.

A question mark matches any single character; an asterisk matches any sequence of characters.

If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

HLOOKUP function

https://support.microsoft.com/en-us/office/hlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f?ui=...

HLOOKUP searches for a value in the first row of a range of cells.

As soon as the has been found and the correct column has been selected, the HLOOKUP jumps down a number of lines (line index) and returns the value found here.

Thank you for your patience and time.

Nikolino

I know that I don't know (Socrates)

[#3]

@Nao_saito 

HLOOKUP() works from top to down; VLOOKUP() from left to right. If I understood you screenshot correctly you try to use HLOOKUP() from down to top, that doesn't work.

Use XLOOKUP() or INDEX/MATCH alternatively.