Create this 2 column table:
0.....6
10...15
20...19
30...24
45...27
60...30
75...34
Assume that table is in the range A2:B8.
Then, this formula entered in F17:
=IFERROR(LOOKUP(D17,A2:B8),0)
Create this 2 column table:
0.....6
10...15
20...19
30...24
45...27
60...30
75...34
Assume that table is in the range A2:B8.
Then, this formula entered in F17:
=IFERROR(LOOKUP(D17,A2:B8),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