I love when people here speak in their native tongues.

The Lounge

Post #1032467 ◀ PREV NEXT ▶

Joined: 12/28/2002

Posts: 166,281

Likes: 79,891

PhotoHokieNC

Posted: 11/20/2023 at 05:16 PM ET

(In response to this post by Late 80s Hokie)

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

42** -- FfxStationHokie Nov 20, 2023 at 03:53 PM ET

FfxStationHokie • 11/20/23 03:53 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