VBA - different formulas and matching values

1. Calculate value into column „Profiili kogus“ – If value in column „Aken/Uks“ is set to Uks then the formula should be following: =2*column „Kus“ value + column „lus“ value
If the value in column „Aken/Uks“ is set to Aken then the formula should be following: =2*( column „Kus“ value + column „lus“ value).

2. Calculate value into column „Pro“ – search matching values between columns Tüüp; Süsteem in sheet „calc“ and columns Tüüp; Süsteem in sheet „sheet“. Matching values must be on the same row. Then look from which column in sheet „sheet“ the value must be taken. It should be the column which headline responds to column „toon“ value in sheet „calc“.

The formula in column „Pro“ should be following: =“Profiil kogus“ value/1000*value defined above.

3. Calculate value into column „Paig“ - search matching values between columns Tüüp; Süsteem in sheet „calc“ and columns Tüüp; Süsteem in sheet „sheet“. Matching values must be on the same row. The value must be taken from the same row of column „Paigaldus“ in sheet „sheet“.

The formula in column „Paig“ should be following: =“Tk“ value* value defined above.

VBA code should be working for range of rows(10:35) in sheet „calc“.

I really appreciate your help and feel very open for additional questions if needed. I’ve also added a example file with one sample row.

Thank you in advance!

Hi,

I had originally thought that the combination of the Tüüp & Süsteem values might create a unique descriptor to lookup in the 'sheet' sheet. However it doesn't since the Tüüp identifiers are not unique

You need to create a unique Tüüp identifier on the 'sheet; sheet. At the moment the B3 value (Kahepoolse ukse materjal meetri hind) occurs in several places, B5, B12, none of which are spelled quite ths same as the A10 value (Kahepoolse ukse materjal).

Please make sure there is a one to one unique lookup between the values on the calc sheet and the 'sheet' sheet. Then reupload the workbook when you have done that.

Hi,

See attached.

N10:

Formula:

Please Login or Register  to view this content.

U10:

Formula:

Please Login or Register  to view this content.

X10:

Formula:

Please Login or Register  to view this content.

You didn't mention the Kls column V, however
V10

Formula:

Please Login or Register  to view this content.