Thread
:
need to lookup a value in one column to fill in another
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett