Sign In or Create Account

What do you know today, that you did not yesterday?

3 lurkers | 173 watchers

GregP Mar 2021 3:56pm, 10 Mar 2021 125,724 posts	0 GregP The ONS use HLOOKUP. Nobody uses HLOOKUP. Nobody with any self respect, anyway. I'm horrified. =IF(HLOOKUP(Working!$B$21,Working!$C$23:$T$51,11,FALSE)="","n/a",HYPERLINK(HLOOKUP(Working!$B$21,Working!$C$23:$T$51,11,FALSE),"Link"))
GordonG Mar 2021 4:02pm, 10 Mar 2021 8,521 posts	0 GordonG Those ONS people are a bunch of !B/$"/$s, aren't they!
NDWDave Mar 2021 4:06pm, 10 Mar 2021 14,278 posts	0 NDWDave I do occasionally use vlookup in scratch spreadsheets when I’m really lazy but get barbed comments from my direct reports if they ever get spotted. Hlookup is a step too far... Index(match... is the favoured approach. Or Python/R
GregP Mar 2021 4:12pm, 10 Mar 2021 125,726 posts	0 GregP Quite, Dave. Quite.
Fizz :-) Mar 2021 4:16pm, 10 Mar 2021 5,397 posts	0 Fizz :-) Xlookup . . .
NDWDave Mar 2021 4:25pm, 10 Mar 2021 14,279 posts	0 NDWDave Fookup
Fizz :-) Mar 2021 5:12pm, 10 Mar 2021 5,399 posts	0 Fizz :-) I like it. But then I’m lazy.
rf_fozzy Mar 2021 7:07pm, 10 Mar 2021 13,596 posts	0 rf_fozzy I think I used VLookup once, but no-one noticed and I got away with it
swittle Mar 2021 5:59am, 11 Mar 2021 73,647 posts	0 swittle What a Zamboni does.
GregP Mar 2021 7:14am, 11 Mar 2021 125,737 posts	0 GregP [looks horrified at Swit - that said I have no idea how it does it]

About This Thread

Maintained by fetcheveryone

Ni ddychwel doe

Related Threads

Eureka! Look what I figured out Nov 2023
Mind Blowers Jul 2023
Scrapbook Oct 2024
Wales, double-decker buses, football pitches: take a back seat Oct 2024
Enriching stuff to read, listen to or watch :-) Apr 2022
Now *there's* a headline. May 2020

discovery
interesting

Back To Top

X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!

Get Started
Click here to join 113,278 Fetchies!

Already a Fetchie? Sign in here