Frontpage template

VLOOKUP & MATCH Two-Way Lookup Country & Capitals to get information

Inside the VLOOKUP function, the column index argument is normally hard-coded as a static number. However, you can also create a dynamic column index by using the MATCH function to locate the right column.

VLOOKUP & MATCH Two-Way Lookup Country & Capitals to get information
MH17 Australia and Netherlands accuse Russia of complicity

Foreign minister says Australia will seek financial compensation from Moscow

MH17: Australia and Netherlands accuse Russia of complicity

'I'm not sorry I said it' Erykah Badu on music, motherhood and wildly unpopular opinions

The neo-soul star has sold millions, raised three kids and embodied wokeness before the word was even coined. But can her reputation survive January’s ‘I saw something good in Hitler’ comment?

'I'm not sorry I said it': Erykah Badu on music, motherhood and wildly unpopular opinions
NBA playoffs Record-setter LeBron James scores 44 as Cavaliers level series with Celtics

Cleveland beat Boston 111-102 in NBA Eastern Conference finals. Series is now square at 2-2 as teams head to Boston for Game 5. LeBron now has most field goals in NBA playoffs history

NBA playoffs:Record-setter LeBron James scores 44 as Cavaliers level series with Celtics

Chloë Sevigny ‘I didn’t want to name names. I think they’re commonly known as assholes anyway’

More than 20 years ago, the actor was anointed ‘the coolest girl in the world’. As her new film opens, she talks about A-list movie stars hogging the best TV roles and why she chose not to add her voice to #MeToo

More than 20 years ago, the actor was anointed ‘the coolest girl in the world’. As her new film opens, she talks about A-list movie stars hogging the best TV roles and why she chose not to add her voice to #MeToo

Chloë Sevigny: ‘I didn’t want to name names. I think they’re commonly known as assholes anyway’
Revealed UK’s push to strengthen anti-Russia alliance

Exclusive: ministers will use series of summits to pursue containment strategy and urge rethink of diplomatic dialogue

Exclusive: ministers will use series of summits to pursue containment strategy and urge rethink of diplomatic dialogue

Revealed: UK’s push to strengthen anti-Russia alliance
Donald Trump dictated note saying he was 'astonishingly' healthy, doctor says

Harold Bornstein tells CNN Trump wrote letter saying he would be ‘healthiest individual ever elected to the presidency’

Harold Bornstein tells CNN Trump wrote letter saying he would be ‘healthiest individual ever elected to the presidency’

Donald Trump dictated note saying he was 'astonishingly' healthy, doctor says
A queen's selfie and a save the bees demo Friday's best photos

The Guardian’s picture editors bring you photo highlights from around the world. Selected by Natasha Rees-Bloor. Fri 27 Apr 2018 14.11 BST

The Guardian’s picture editors bring you photo highlights from around the world. Selected by Natasha Rees-Bloor. Fri 27 Apr 2018 14.11 BST

A queen's selfie and a save the bees demo Friday's best photos

Bolts from the blue readers' photos on the theme of storm

we asked you to share your photos on the theme of storm via GuardianWitness. Here’s a selection of our favourites

Bolts from the blue: readers' photos on the theme of storm
Gig review MARTIN TURNER – 100 Club, London, 14 October 2017

Turner's only London show. He'll be performing Wishbone oldies with his new band, followed by a second set where they'll play the 1972 'Argus' LP in full.

Gig review: MARTIN TURNER – 100 Club, London, 14 October 2017

This site is an experimental testcase to approach The Guardian container/grid layout

Unlimited flexibility

Read more

Fleetwood Macduet album to be released

Former members Lindsey Buckingham and Christine McVie return with their duet album in May, which will feature John McVie and Mick Fleetwood

Fleetwood Mac duet album to be released
Finlandto end basic income trial after two years

Government rejects request for funds to expand scheme and plans stricter benefits rules

Government rejects request for funds to expand scheme and plans stricter benefits rules

Finland to end basic income trial after two years

Leni Riefenstahlarchive to throw new light on Hitler's film-maker

Critics fear bequest will fuel new wave of fanaticism among those who continue to revere the German propagandist and neo-Nazi icon

Leni Riefenstahl archive to throw new light on Hitler's film-maker
‘We’ve got more money swirling around’how streaming saved the music industry

Thanks to the success of Spotify, big stars from Ed Sheeran to Fleetwood Mac are cashing in, while even artists in niche genres such as Danish cloud rap are flourishing, sometimes without record labels. Is this unexpected revival here to stay?

‘We’ve got more money swirling around’: how streaming saved the music industry
Modiglianisets world record with estimate in excess of $150m

Nu couché (sur le côté gauche) may fetch more than £170.4m paid for another nude in 2015

Modigliani sets world record with estimate in excess of $150m
Scientists plan huge European AI hub to compete with US

Exclusive: In an open letter, the scientists say the proposed Ellis institute is essential to avoid brain drain to big tech firms

Scientists plan huge European AI hub to compete with US

The Recap sports email - sign up

Time, please: is drinking becoming as socially unacceptable as smoking?

Drinking is ingrained in our social life – much as cigarettes were until public health campaigns led to a huge cultural shift. With many young people eschewing alcohol, the beginning of the end of booze Britain is in sight

Time, please: is drinking becoming as socially unacceptable as smoking?
Netflix’s ‘new world order’ a streaming giant on the brink of global domination

The online entertainment company, which boasts 125 million subscribers, has become so powerful it can even afford to snub Cannes. Are cinephiles – and conventional broadcasters – right to fear for the future?

The online entertainment company, which boasts 125 million subscribers, has become so powerful it can even afford to snub Cannes. Are cinephiles – and conventional broadcasters – right to fear for the future?

- Menopause I find my husband’s sexual advances off-putting
  
  He uses my feet to masturbate – but as it’s the only regular pleasure he gets from me, I grin and bear it
  
  He uses my feet to masturbate – but as it’s the only regular pleasure he gets from me, I grin and bear it
- China's Weibo reverses ban on 'homosexual' content after outcry
  
  Microblogging site’s move to create ‘harmonious’ environment prompted protests under the hashtag #Iamgay
  
  China's Weibo reverses ban on 'homosexual' content after outcry

- NBA playoffs first-round matchups set on dramatic final night of regular season
  
  Timberwolves defeat Nuggets in overtime for final berth in West. Sixers win franchise-record 16th straight game to clinch No3 seed
  
  NBA playoffs: first-round matchups set on dramatic final night of regular season
- Do video games make children violent? Nobody knows – and this is why
  
  The sorry state of research into one of the world’s biggest entertainment industries is leaving us in the dark
  
  Do video games make children violent? Nobody knows – and this is why

Raspberry Pi small is beautiful

The Guardian view on the Raspberry Pi: small is beautiful

The Guardian view on the Raspberry Pi: small is beautiful
Want to be more assertive in life? This former dominatrix will show you how

Kasia Urbaniak has mastered the dominant position with men, and is a master at unpicking power dynamics

Want to be more assertive in life? This former dominatrix will show you how
Skripals poisoned from front door of Salisbury home, police say

Specialists report highest concentration of nerve agent at home of Russian spy

Skripals poisoned from front door of Salisbury home, police say

Nicolas Sarkozy faces formal investigation over alleged Libya funding

Nicolas Sarkozy faces formal investigation over alleged Libya funding

Nicolas Sarkozy faces formal investigation over alleged Libya funding
How we made Doom the video game

The creators of the legendary 90s first-person shooter reveal how they were inspired by Tom Cruise – and a Swiss surrealist

How we made the video game Doom

The long read

Just when the baby boomer is loving the empty nest, here’s the boomerang child . . .

For parents who have been enjoying the freedom of living child-free, now comes research to spoil it all
Jessica Jones: season two review

The finale of season one set the bar high – but a slow and flabby start to the second is slightly worrying. Netflix’s difficult second outing for its mould-breaking superhero.

Jessica Jones: season two review
Is cannabis the answer to older people’s booze problems?

Baby boomers and Generation X-ers, take note: mindful drinking is not the only solution to mindless drinking.

Is cannabis the answer to older people’s booze problems?

Donate

bertverberne.com

Farewell to NME: a rock'n'roll riot that petered into silence a rock'n'roll riot that petered into silence

Three Billboards Outside Ebbing, Missouri, the bleak, bitter, blistering comedy about injustice in small-town America, took the major honours at the 2018 Bafta film awards on Sunday night.

Farewell to NME: a rock'n'roll riot that petered into silence
The best new Android and iPhone games for 2018 Android and iPhone games for 2018

Be a neighbourhood god in The Sims Mobile, a Viking hero in Oddmar or start a craft beer empire in Brew Town. Along with Fortnite, Evoland 2, Trick Shot 2 and more new mobile games to try

The best new Android and iPhone games for 2018
Farewell Penny Dreadful, you "great fertile bitch of evil" You "Great Fertile Bitch of Evil"

After three seasons, the twisted horror story for our times has been cancelled. I’ll miss it all – the night creatures, the prostitute armies and the suitors from Hell.

Farewell Penny Dreadful, you "great fertile bitch of evil"
Disillusioned with Game of Thrones? Try Penny Dreadful with Game of Thrones? Try Penny Dreadful

Showtime’s macabre Victorian yarn might not have had the same fanfare of its HBO peers but its layered pulp burlesque shtick is well worth a watch.

Disillusioned with Game of Thrones? Try Penny Dreadful

Videos

Videos
2:29

Play Video
01:09

Play Video
14:49

Play Video

Ryanair chief: we won't bow to laughable demands from pilots

The Ryanair chief executive, Michael O‘Leary, has warned that the airline will not bow to “laughable” demands from pilots and would rather see strikes or disruptions than undermine its productivity.

Gallery

Ryanair chief: we won't bow to laughable demands from pilots
10cc: How we made I'm Not in Love

"The drummer said it was crap and we were just about to scrap the whole thing. Then I heard the studio’s secretary singing it and the window cleaner whistling it"

Gallery

10cc: How we made I'm Not in Love

Beyond retro why 80s-obsessed producers are taking Rihanna back in time

Remixers like Initial Talk and Tronicbox are revitalising modern pop hits with a vintage makeover

Gallery

Beyond retro: why 80s-obsessed producers are taking Rihanna back in time
Can we really trust Google as judge, jury and executioner of online ads?

Can we really trust Google as judge, jury and executioner of online ads?

Gallery

Can we really trust Google as judge, jury and executioner of online ads?
Uma Thurman breaks silence over Harvey Weinstein

The Kill Bill actor told the New York Times of encounter in London: ‘He tried to shove himself on me. He tried to expose himself’

Uma Thurman breaks silence over Harvey Weinstein
Cosmic dawn: astronomers detect signals from first stars in the universe

‘Revolutionary’ observations suggest the first stars appeared 180m years after the big bang – and may hold information on dark matter

Gallery

Cosmic dawn: astronomers detect signals from first stars in the universe

Top 10 affordable hotels, hostels and B&Bs in Amsterdam

As Eurostar’s direct London-Amsterdam service launches, we pick great-value accommodation in this popular city-break destination

When good TV goes bad: how The Fall fell from grace

After a compelling first series, the serial killer thriller began to lose its grip. What followed was a cavalcade of preposterousness

Do video games make children violent? Nobody knows – and this is why

The sorry state of research into one of the world’s biggest entertainment industries is leaving us in the dark

Leni Riefenstahl archive to throw new light on Hitler's film-maker

Critics fear bequest will fuel new wave of fanaticism among those who continue to revere the German propagandist and neo-Nazi icon

Top 10 codes, keys and ciphers

Kevin Sands, author of The Blackthorn Key, picks his favourite keys, codes and ciphers throughout history, from the Caesar shift to the Enigma machine

Chloë Sevigny: ‘I didn’t want to name names. I think they’re commonly known as assholes anyway’

More than 20 years ago, the actor was anointed ‘the coolest girl in the world’. As her new film opens, she talks about A-list movie stars hogging the best TV roles and why she chose not to add her voice to #MeToo

10cc: How we made I'm Not in Love

"The drummer said it was crap and we were just about to scrap the whole thing. Then I heard the studio’s secretary singing it and the window cleaner whistling it"

Disillusioned with Game of Thrones? Try Penny Dreadful

Showtime’s macabre Victorian yarn might not have had the same fanfare of its HBO peers but its layered pulp burlesque shtick is well worth a watch.

Jessica Jones: season two review

The finale of season one set the bar high – but a slow and flabby start to the second is slightly worrying. Netflix’s difficult second outing for its mould-breaking superhero.