search a column

  • Thread starter Thread starter DKY
  • Start date Start date
D

DKY

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
 
Not necessary to look at the file. Suggest you consult HELP index for
VLOOKUP.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy columns and paste with blank column between 5
Transfer array element offset value to a matched value 3
Comparing numbers 1
Transpose?? 6
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Search for empty cells and move cells next to 10
Matching Columns 2
selecting cells and getting their content into a string? 1

Back
Top