or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

101 watchers
run free
run free
Nov 2019
12:31am, 26 Nov 2019
3,647 posts
  •  
  • 0
run free
Agree spr IFError() is much neater
GregP
GregP
Nov 2019
6:56am, 26 Nov 2019
116,263 posts
  •  
  • 0
GregP
+1

As often as not I use lookup because the syntax is easier and cow-orkers are more likely to understand it.
GlennR
GlennR
Nov 2019
8:07am, 26 Nov 2019
46,513 posts
  •  
  • 0
GlennR
A likely story. I don’t believe your cow-orkers could tell LOOKUP from their moon
larkim
larkim
Nov 2019
8:56am, 26 Nov 2019
9,570 posts
  •  
  • 0
larkim
Having grown up with vlookup in my working years, I must admit to not finding the index/match syntax flowing in the same way that vlookup does. It's an old friend, I can work around it's foibles even if it is imperfect and limited.

I aspire to becoming an index/match disciple.
run free
run free
Nov 2019
1:47pm, 26 Nov 2019
3,650 posts
  •  
  • 0
run free
Young Larkim - index match is old news now - aspire to be a power pivot disciple
GlennR
GlennR
Nov 2019
1:55pm, 26 Nov 2019
46,537 posts
  •  
  • 0
GlennR
Power pivot: can't code, no problem.
larkim
larkim
Nov 2019
2:14pm, 26 Nov 2019
9,587 posts
  •  
  • 0
larkim
I feel so out of touch...
larkim
larkim
Nov 2019
2:15pm, 26 Nov 2019
9,588 posts
  •  
  • 0
larkim
(Though I can code, I do enjoy that!)
GlennR
GlennR
Nov 2019
2:16pm, 26 Nov 2019
46,539 posts
  •  
  • 0
GlennR
Excel can't do an NPV calculation properly. I'm sure as hell not trusting it with a data table.
run free
run free
Nov 2019
3:38pm, 26 Nov 2019
3,651 posts
  •  
  • 0
run free
Eh? You can use the DAX expression language in PowerPivot or program it using VB. The data table is actually translated into an "OLAP" tabular table. It ain't just a lookup data table. eek am out before I rant on!!!

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...

Related Threads

  • excel
  • support
  • tech
  • work








Back To Top

Tag A User

To tag a user, start typing their name here:
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,955 Fetchies!
Already a Fetchie? Sign in here