lookup first value in a column

[wolfm]

Have been researching Vlookup and Index functions, but having trouble grasping them.
In Worksheet 2, cell F18, I want automatically entered the first numeric value that appears in column AL of worksheet 1.
Seems very simple, but cannot get it to work. Any help would be appreciated. Thank you!

[tigeravatar]

wolfm,

Give this a try, adjust range to suit:

Please Login or Register  to view this content.

[wolfm]

Wow, I don't think I could have figured that out. It worked! Thank you!