Need some help with excel VLOOKUP (AC > Excel > AC)

[Mats_Knutsson]

Hi,
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".
Best regards,
Mats with 9000+ objects of various correctness

[Erwin Edel]

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?

[DGSketcher]

If your schedule is as simple as ID & Name can't you have the schedule "group identical" items which should narrow down the misspelt names for correction?

I can see the value in data links e.g. ID points to a specification name / description, but VLOOKUP seems a bit overkill as a spell checker.

[Mats_Knutsson]

DGSketcher wrote:
If your schedule is as simple as ID & Name can't you have the schedule "group identical" items which should narrow down the misspelt names for correction?

I can see the value in data links e.g. ID points to a specification name / description, but VLOOKUP seems a bit overkill as a spell checker.

that's what we do right now. it's four bog models and it's a matter of several days work to do it through the schedules....and it's the most boring work ever... 😉