Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
indirect

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

INDIRECT()

ResolvedVersion 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.

TrustPilot
TrustScore 4.9 / 5       2447 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

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

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.14 secs.