No. Especially with the lookup value sometimes being a number, and
sometimes being a letter.
As said, I've done a workaround that works, and I appreciate the answer. At some point, just for curiosity, I'll see if what Beerman and Hokie Hokie are saying are true.
Thread Replies (8)
I found a workaround, but question on HLookup in Excel. I setup an
-- Late 80s Hokie
Nov 20, 2023 at 01:54 PM ET
Late 80s Hokie
•
11/20/23 01:54 PM ET
How the H should we know? Good luck!**
-- TomTurkey
Nov 20, 2023 at 09:05 PM ET
TomTurkey
•
11/20/23 09:05 PM ET
I love when people here speak in their native tongues.**
-- PhotoHokieNC
Nov 20, 2023 at 05:16 PM ET
PhotoHokieNC
•
11/20/23 05:16 PM ET
If lookup_value is smaller than the smallest value in the first row, #N/A
-- pburg_hokie
Nov 20, 2023 at 02:50 PM ET
pburg_hokie
•
11/20/23 02:50 PM ET
No. Especially with the lookup value sometimes being a number, and
◄
-- Late 80s Hokie
Nov 20, 2023 at 03:30 PM ET
Late 80s Hokie
•
11/20/23 03:30 PM ET
I think your search lookup has to be in Alphabetical order.
-- Hokie Hokie
Nov 20, 2023 at 02:16 PM ET
Hokie Hokie
•
11/20/23 02:16 PM ET
I think that this is it. Or at least PART of it. I went back to an earlie
-- Late 80s Hokie
Nov 20, 2023 at 09:44 PM ET
Late 80s Hokie
•
11/20/23 09:44 PM ET
Doesn't seem like it should, unless "H" is a magic letter for some reason
-- Beerman
Nov 20, 2023 at 02:06 PM ET
Beerman
•
11/20/23 02:06 PM ET