Vlookup

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I am trying to move pieces data from a table on one
worksheet to another. I need to search the first table
for data I want and put it in the second table. I am
trying to sort by techID without having to sort,
copy,paste. Because the data is always being added to.


The columns are all named ranges
TechID InvoiceNum Date INV. TOTAL


I tried this but get #NA
VLOOKUP(A1,InvoiceNum,TechID,FALSE)


Any Ideas?
 
I have been working at this, I got the VLookup to work! I
can get the first occurance but I don't know how to get
every occurance like if I were to use Auto Filter. Can I
do this?

Thanks.
 
Back
Top