Microsoft Office Forums - View Single Post - Look up an array based on user input

Thread: Look up an array based on user input

View Single Post

Old

01-06-2011, 08:51 PM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

If your user places the name of the chosen array in cell A2, then use the INDIRECT function within your VLOOKUP function like this:

Code:

=VLOOKUP(B25,INDIRECT(A2),8)

Cheers,

Reply With Quote