View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default need to lookup a value in one column to fill in another

No pun intended but lookin the help index for LOOKUP or MATCH

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jspen" wrote in message
...
I have only 4 columns in a log book, the first is the Customer name the
second is the customer number, the other two are some date columns. I've
been manually entering the customer name and number for the past year. I
want to be able when adding a new row to type in the customer number and
it
will lookup above to find the customer name. is there anyway to do this?
thanks