# Category: 30XL30D

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

## 30 Excel Functions in 30 Days: Conclusion

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

## 30 Excel Functions in 30 Days: 30 – INDIRECT

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

## 30 Excel Functions in 30 Days: 29 – CLEAN

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

## 30 Excel Functions in 30 Days: 28 – HYPERLINK

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

## 30 Excel Functions in 30 Days: 27 – SUBSTITUTE

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

## 30 Excel Functions in 30 Days: 26 – OFFSET

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

## 30 Excel Functions in 30 Days: 25 – REPLACE

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

## 30 Excel Functions in 30 Days: 24 – INDEX

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

## 30 Excel Functions in 30 Days: 23 – FIND

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