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 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.
I know that I don't know (Socrates)