Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to search in one column, and replace in the other column if fo | Excel Discussion (Misc queries) | |||
Search a column for values, return a value from adj column | Excel Worksheet Functions | |||
LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Search one column and return value from next column | Excel Discussion (Misc queries) |