Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » 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)
Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 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.
