search a column
 

actually, curious how to do much more than that. Really new to this V
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 ite
number in column A row 1, excel will search column D to find tha
number and put the corresponding price from column E into Column B ro
1. Any suggestions

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=26139

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

search a column
 

In B2 put in

=if(A2<"",vlookup(A2,$D$1:$E$200,2,False),"")

Change 200 to reflect the number of rows in your lookup table.

then drag fill down the column.

--
Regards,
Tom Ogilvy


"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