Nov 18 2020 06:40 PM
以下のように数字を引数としても、正しく数値が表示されません。セルの書式設定ですべて文字列にしているのですが、うまくいきません。理由の分かる方いらっしゃったら教えていただけますと幸いです。
Nov 18 2020 08:40 PM
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
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)
Nov 18 2020 11:57 PM
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.