Thread
:
Automatic data entry
View Single Post
#
9
Posted to microsoft.public.excel.misc
paul
Posts: n/a
Automatic data entry
= vlookup(A1,sheet2!distance_table,match(B2,sheet2!c ity2namerow,0),false)
--
paul
remove nospam for email addy!
"phil2006" wrote:
My grid is on sheet2, the city names are in row 1 and column A. I am
typing the names on sheet 1 in columns 1 and 2 hopin to achieve a
distance in column 3.
Thanks!!
--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread:
http://www.excelforum.com/showthread...hreadid=555195
Reply With Quote