OK, here's the formula using cell addresses instead of named ranges.
=VLOOKUP(A2,ControlInterface!A:J,MATCH(A5,ControlInterface!A1:J1,0),0)
OK, here's the formula using cell addresses instead of named ranges.
=VLOOKUP(A2,ControlInterface!A:J,MATCH(A5,ControlInterface!A1:J1,0),0)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks