i have two lists in two seperate excel sheets
one sheet has a list of 400 serialnumbers like this -- R0123456789
i have another list of 150 serialnumbers that need to be looked up and marked on the second list as found by marking the column next to it as found
needs to be done veryquicklyplease. like befor lunch
just needs the right lookup fomula i cant think of
22 freelancers are bidding on average $36 for this job
I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. Yes, you are right, just using the lookup function...,but some trick...more in PM.