How did you get one for up-down? Did it use VLOOKUP? If not, it
probably should. And, you could use HLOOKUP for left-right.

Or maybe, you used Find. If so, you should be able to tweak it to go
l-r.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi all
I am trying to write a macro that will search row 1 for a text value I
define and then return the column letter. I managed to write one for up-down
and now i need to find one for left-right...

Thanks
Ben H.