Hi
Can anyone help me with a lookup query I have?
I have a set of data set out similar to below...
Jan Feb March April
2 6 8 2
I have a =MIN formula at the end of the row that tells me the lowest number in that row, which would be 2 in this case. However I would like a formula that also tells me the last month the lowest figure fell in, which would be April.
It's probably a real easy formula but I'm stuck at the moment, must be a blonde moment!
Bookmarks