MS Excel / VBA help thread

You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.

•

hugo7
Does anyone have a sense of how hard(?) this will be for Excel:
- I have a list of 2-200 rows with Ids (list A) that will vary from time to time, and a list of 16k rows (list B) that will be static (or sometimes updated)
- I want to lookup ids in list A to check if they appear in list B.
Will looking up against a sheet with 16k rows be fine or will it constantly fuck up?

Cheers.

•

Chalfie in reply to @hugo7

POWER QUERY

•

hugo7 in reply to @Chalfie

No 😊

It needs to be a suggested tactical solution for the semi-inept. I can ask them to do a look up on sheet A before uploading, but I can't really ask more than that.

I guess I could find out if they are allowed macros.

But we're saying it'll shit the bed.

Ah! Back to the drawing board.

About

Avatar for Chalfie @Chalfie started