Hlookup Calculation

[Inactive User]

Hi Everyone,

I want to perform Hlookup like calculation in alteryx, Find below screenshot:

Can Anyone Help, Thanks in Advance !

[mceleavey]

Hi @Inactive User ,

can you provide some mock data of what you're trying to achieve?

Thanks,

M

[Inactive User]

Hi @mceleavey 

Find attached file, where i have mention two tables and formula, which i want to achieve.

Thanks !

[mceleavey]

Ouch.

So the short answer here is, no. That's a really awful, manual Excel calculation with no logical format and so there's no way to relate the values.

In essence you have three tables:

Table one:

Table1
			Col1	-	-	-
			Col2	-	-	-
			Col3	-	-	-
			Col4	2020	1014	10098

Table two:

ID	Col1	Col1 Val	Col5	a	b	c
1	A	0.00		0	0	0
2	B	0.60		1212	0	12238776
3	C	0.25		505	0	5099490
4	D	0.56		1131.2	0	11422858
5	E	0.36		727.2	0	7343266

Table three:

ID	a	b	c
1	0.00	0.26	5
2	0.60	0.35	2
3	0.25	0.36	8
4	0.56	0.41	0.35
5	0.36	4	0.14

There doesn't appear to be any logic relating the things you are trying to do. This is a very Excel way of doing things.

I would recommend getting the data in a logical format, and then you can simply multiply the things together.

As it stands, you want multiply random cells. You need to make the data mean something first, and create a logical association between them.