With your table in the range D2:F13...
A2 = some value
=LOOKUP(A2,D2:F13)
You can reduce the table to:
51........0:11
251......0:12
401......0:13
501......0:14
551......0:15
601......0:16
With your table in the range D2:F13...
A2 = some value
=LOOKUP(A2,D2:F13)
You can reduce the table to:
51........0:11
251......0:12
401......0:13
501......0:14
551......0:15
601......0:16
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