Try this..
Formula:
=lookup(A1,{0,5,7,10,15,20},{0,700,900,1000,1100,1200})
you can also use ranges instead of Arrays...
Try this..
Formula:
=lookup(A1,{0,5,7,10,15,20},{0,700,900,1000,1100,1200})
you can also use ranges instead of Arrays...
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks