Updating a simple list

Hi, I was wondering if anyone can help me figure this one out.

I have a table with a column of items and a corresponding column with values TRUE or FALSE (false is default). See FIG A

Now I’ve been sent an updated version of the table. Some elements have been added and others have been removed. The problem with the updated table is that it does’t have the TRUE/FALSE info from the original table. See FIG B

So I’d like add the TRUE/FALSE values from the previous table but only to the corresponding items. Leaving new items with FALSE as default. See FIG C

Is there an easy way to accomplish this?

Best regards and thank you for taking the time to read my post!

I tend to fall back to VLOOKUP and IF for things like this; others have more elegant solutions. There are two sheets in sample file, Original and New

VLookup_77683.ods (11.0 KB)

Here’s my take…might as well upload, even if @EarnestAl got here first. I’m sure it’s the same basic idea.

Yep, almost to the letter. EarnestAI separated the source data in another sheet. I added a separate flag column for indicating if the FALSE was defaulted or not.

PullFromEarlierTable.ods (11.9 KB)

1 Like

IFNAIFERROR exists since LO5

Hard to get out of old habits :thinking:

But certainly =IFNA(VLOOKUP(A1;$Original.$A$1:$B$5;2;0);0) is much better. Cheers, Al