Vlook up with multiple condition vba formula request

[grlnexdor]

Hi Everyone,

I'm still learning this VBA thingy. Unfortunately I am not able to create a simple VBA code for vlook up. let alone add in additional IF function.

Can someone please help me in creating a VBA for attached worksheet as this will be applicable for 50 products.

Basically I just want to populate whatever is in the table on the right in my another table for calculation purposes.


Thanks!

[jewelsharma]

try the following code:

Please Login or Register  to view this content.

Also see attached - PRODUCT VBA.xlsm
HTH!

[humdingaling]

is there a specific reason the table must have "empty lines" in table 2?

not sure why you are having to resort to vba solution

a sumproduct should work for you
if empty lines are required a simple helper column can be used to assist

by far easier to manage update and upkeep than a vba solution in this case
especially if you are not strong at it

[grlnexdor]

Hi jewelsharma

this works beautifully!!

Thanks!

Saves a lot of time for me.

[grlnexdor]

Hi Humdingaling,

the empty lines in table 2 represents others stuffs but I didnt include it in the table cosh its not necessary to be calculated.

Anyway, i didnt thought sumproduct would work in this. I only thought vlookup and if would.

thanks for sharing! always happy to learn new things.

[grlnexdor]

Hi,

It's me again, I have tried to update the codes according to my datas but ".Cells(iRow, iCol) = iAmount" is being highlighted as an error. it states, "Cannot change this part of a Pitvottable report".

Please Login or Register  to view this content.

Am I missing anything?

[jewelsharma]

please attach the workbook with error. However, when you change the range in MATCH function, you also need to adjust the addition as:

Please Login or Register  to view this content.

Do attach the workbook if anything.

[grlnexdor]

Hi Jewelsharma,

I have tried the latest code you have provided but now the below is coming out as an error.

Please Login or Register  to view this content.

I have attached the worksheet as requested.

Thanks

[jewelsharma]

Mate,
We cannot change the structure of the workbook and expect the same code to work again. The code needs to be suitably modified as well. See attached and trailing:

Please Login or Register  to view this content.

sumproduct furmula 2.xlsm

Ideally, you should raise this via a new thread (for continuity you may provide a link to this thread in the new thread). This way you will receive quicker assistance from forum members.
Cheers!

[grlnexdor]

Hi jewelsharma,

I see.. thanks, i'll do that next time.

Many thanks in assisting me on this.. appreciate it!