I use the Vlookup a lot and sometimes in some very large spreadsheets.
As you can imagine I spend a lot of time counting columns to find the
column index number. Is there a formula I can use that will do that
counting for me? For example if my lookup value is in column A and my
return value is in column C the answer for this formula should be 3.

Thank you,
Shelly


--
shelly2
------------------------------------------------------------------------
shelly2's Profile: http://www.excelforum.com/member.php...o&userid=29852
View this thread: http://www.excelforum.com/showthread...hreadid=495522