indirect
Train Strikes - 7th, 8th & 9th May 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » INDIRECT()

INDIRECT()

resolvedResolved · High Priority · Version 2010

INDIRECT()

Can you help me with this:

D1 contains "Jan 2017 NHSP Bookings"

This works (result is 126):

=VLOOKUP([@[Healthroster Unit]],'Jan 2017 NHSP Bookings'!$AR$4:$AU$90,4,FALSE)

This gives a #REF! error:

=VLOOKUP([@[Healthroster Unit]],"'"&INDIRECT("'"&$D$1&"'!"&"$AR$4:$AU$90"),4,FALSE)

RE: INDIRECT()

Okay, I spotted it! There shouldn't be anything before INDIRECT except the comma.


 

Excel articles

Please browse our web site to find out more about
advanced+excel+training+in+london and other training courses.

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.05 secs.