## 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...

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...

Thanks for participating in the 30XL30D challenge, that ended yesterday. My favourite Excel function in the series was INDEX — I learned a few useful tricks while researching that one! How about you? As...

Congratulations! You made it to the final day in the 30XL30D challenge. It’s been an long, and interesting, journey, and I hope you learned a few useful things about Excel functions along the way....

Yesterday, in the 30XL30D challenge, we jumped around a workbook, and opened Excel files and websites, by using the HYPERLINK function. For day 29 in the challenge, we’ll examine the CLEAN function. Sometimes the...

Yesterday, in the 30XL30D challenge, we replaced text with the SUBSTITUTE function, and used it to create flexible reports. For day 28 in the challenge, we’ll examine the HYPERLINK function. Instead of manually creating...

Yesterday, in the 30XL30D challenge, we used the OFFSET function to return a reference, and saw that it is similar to the non-volatile INDEX function. NOTE: You can have all of the 30 Functions...

Yesterday, in the 30XL30D challenge, we changed text strings with the REPLACE function, and learned that it can insert characters too. For day 26 in the challenge, we’ll examine the OFFSET function. From a...

Yesterday, in the 30XL30D challenge, we used the INDEX function to return a value or reference, based on a row and/or column number. For day 25 in the challenge, we’ll examine the REPLACE function,...

Yesterday, in the 30XL30D challenge, we found text strings with the FIND function, and learned that it is case sensitive, unlike the SEARCH function. NOTE: You can have all of the 30 Functions content...

Yesterday, in the 30XL30D challenge, we had a light day, with the N function, and learned that can return a number, based on a value. For day 23 in the challenge, we’ll examine the...