VBA code to get the value of a cell based on multiple criteria

Hi,

I have a table. From this table, I need to get the corresponding score of the values in A1, A4, B4 to B12 and C3, D3, E3.

So basically, what I need the macro to do is to look for the values of A1, A4, B4 to B12 and C3, D3, E3 in the table. Once found, I need to return its corresponding score to a specified cell.

Attached is a sample.

Thanks in advance.

Try this

Please Login or Register  to view this content.

Awesome Phuocam!

The code is a bit complicated for a newbie in vba like me. If it's not too much to ask what does the line "Set Dic = CreateObject("Scripting.Dictionary")" do?

Thanks so much.

Hi,

You can see this link: https://docs.microsoft.com/en-us/off...tionary-object