Excel Function Friday: HLOOKUP Finds Current Price

On Day 10 of the 30 Excel Functions in 30 Days series, we looked at the Excel HLOOKUP function. It's similar to VLOOKUP, but looks for values in a horizontal list, instead of a vertical list.

The second example in that HLOOKUP blog post showed how to find a rate in a lookup table, based on the date entered in cell C5. On March 15th, the rate would be 0.25, because the Jan 1st rate is still in effect.

Beyond One Cell

In the comments for the HLOOKUP blog post, Fred said that he got the formula working

Continue reading Excel Function Friday: HLOOKUP Finds Current Price

Related Posts Plugin for WordPress, Blogger...

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest