search a column

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

DKY

well, from what i got out of it the $ were to keep it from changing if
copy the cells down the sheet. but if i wanted to do it once and neve
copy it, i wouldnt use the $. So, for fun i took them away and i
doesnt work at all
 
You must have made a mistake. It should work with no problem in a single
cell without the $ sign.

=if(A2<>"",vlookup(A2,D1:E200,2,False),"")
 
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

Create if partial match then copy and paste data from one cell to another 1
Copy columns and paste with blank column between 5
Want code to copy to ABOVE row 22 column A on sheet 1 10
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Epic Games freebies 2
Clear a "moving" range offset from Target 31
Breaking One Row into Multiple Rows using VBA Macro? 2

Back
Top