Hi Up
The (a$2:A$2493) in the match. Is the list of codes i have. From memory a proper array formula you have to finish it with shift ctrl enter (something like that)
I was original going to do a vlookup but had a problem as data often has to remain on the same lines to return correct results. This can be a problem with end of the day data when a new code is added or change of name.
Here is a picture of the to excels so you can see how it works
cheers
mv
- Forums
- General
- excel formula help
excel formula help, page-20
-
- There are more pages in this discussion • 6 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Featured News
NEWS
Exploration drilling kicks off at Truncheon & Highway East, targeting copper-gold near historic mine
NEWS
New gold and silver soil anomalies uncovered at Black Range, strengthening exploration potential