Title lookup

[Flyingmeatball]

I'm trying to make a dynamic Sumifs function, but using a match function is giving me wrong values. The problem is my columns are dynamic - the data I want won't always be in the same column. However, the header will stay the same. Here is the code I tried running to find which column number I will be searching through:

Sub test()
Dim colnum As Integer

colnum = Application.Match("capital markup", Range("A1:Z1"))

End Sub

However, the match returns strange things. Sometimes it won't find the data at all, and sometimes it returns 17, even if the data is in column C or D. Any suggestions?

Thanks so much!

 

[pgc01]

Hi

Try an exact match:

colnum = Application.Match("capital markup", Range("A1:Z1")[B][SIZE=3][COLOR=blue],0[/COLOR][/SIZE][/B])

Remark: Instead of a worksheet function you could also use the Range.Find() method.

 

[Weaver]

Is case sensitivity causing the match function to miss the header?

 

[Flyingmeatball]

That little 0 makes all the difference. Thanks so much!