Thread
:
search a column
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
search a column
Not necessary to look at the file. Suggest you consult HELP index for
VLOOKUP.
--
Don Guillett
SalesAid Software
"DKY" wrote in message
...
actually, curious how to do much more than that. Really new to this
VB
thing. I have an excel file which looks something like this.
http://dky.sytes.net/pricing.html
and would like to know how to make it so that when I type in an item
number in column A row 1, excel will search column D to find that
number and put the corresponding price from column E into Column B row
1. Any suggestions?
--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread:
http://www.excelforum.com/showthread...hreadid=261398
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]