I need some excel advice 😉. As we all know Ecel is the best BIM tool out there.
I have a schedule from AC with two columns, ID and name. The name should follow a
standard but since the names were entered manually the human factor has caused some
slight mispellings. I have an excel with the correct name for every ID and my idea
was to replace the wrong names with the correct names through ArchiCADs excel connection.
I landed on VLOOKUP which works but needs the ID to be inthe first column and AC puts its
identification code in the first row. What I did is to copy the ID and name columns to a
new spreadsheet and from there perform the VLOOKUP. I suspect there is a way to do this
without having to create an extra spreadsheet. I figure INDEX MATCH or something but I can't
figure it out so if anyone is an ecel guru I'd be happy for advice.
I know this is important excel knowledge and should really find the time to learn more about excel since
we're dealing with more and more data. The dream is to communicate with the AC database directly from excel/web but not yet. BIM-eye
is kind of this solution but I'd like a "sandbox".
Mats with 9000+ objects of various correctness
This is probably too easy to suggest, but if you export the schedule to excel and sort by ID and have your correct excel and sort by ID, can't you just copy the correct values over with a simple copy paste?
I'm sorry, but this sort of caveman excel is what I'd do , so no help with an elegant automatic solution.
Or plan B: spellcheck your export and import it back?