Hey

I think this should be simple but I cant figure it out...

I have some values in a range (E1:E10). I want to find the value
"Test" in that range, and then once I find it, I want to offset 0 rows
and 5 columns over to the right and return the value of that cell.

How would I do this?


Thanks
Todd