HLOOKUP関数について

%3CLINGO-SUB%20id%3D%22lingo-sub-1904941%22%20slang%3D%22ja-JP%22%3EAbout%20the%20HLOOKUP%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1904941%22%20slang%3D%22ja-JP%22%3E%3CP%3EIf%20you%20use%20a%20number%20as%20an%20argument%2C%20the%20number%20is%20not%20displayed%20correctly%2C%20as%20follows%3A%20I'm%20formatting%20all%20the%20cells%20into%20text%2C%20but%20it%20doesn't%20work.%20If%20you%20know%20why%2C%20I%20would%20appreciate%20it%20if%20you%20could%20tell%20me.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Nao_saito_0-1605753592937.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234617i9CAB6FDC8AAC07C7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Nao_saito_0-1605753592937.png%22%20alt%3D%22Nao_saito_0-1605753592937.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1904941%22%20slang%3D%22ja-JP%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1905550%22%20slang%3D%22de-DE%22%3ESubject%3A%20HLOOKUP%E6%95%B0%E3%81%84%E3%81%A6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1905550%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F874180%22%20target%3D%22_blank%22%3E%40Nao_saito%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20range_lookup%20is%20FALSE%20and%20lookup_value%20is%20text%2C%20you%20can%20use%20the%20wildcard%20characters%2C%20question%20mark%20(%3F)%20and%20asterisk%20(*)%2C%20in%20lookup_value.%3C%2FP%3E%3CP%3EA%20question%20mark%20matches%20any%20single%20character%3B%20an%20asterisk%20matches%20any%20sequence%20of%20characters.%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20find%20an%20actual%20question%20mark%20or%20asterisk%2C%20type%20a%20tilde%20(a)%20before%20the%20character.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHLOOKUP%20function%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EHLOOKUP%20searches%20for%20a%20value%20in%20the%20first%20row%20of%20a%20range%20of%20cells.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EAs%20soon%20as%20the%20has%20been%20found%20and%20the%20correct%20column%20has%20been%20selected%2C%20the%20HLOOKUP%20jumps%20down%20a%20number%20of%20lines%20(line%20index)%20and%20returns%20the%20value%20found%20here.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EThank%20you%20for%20your%20patience%20and%20time.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3ENikolino%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EI%20know%20that%20I%20don't%20know%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

Nao_saito_0-1605753592937.png

 

2 Replies
Highlighted

@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)

Highlighted

@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.