Vlookups and roundup

[Shank]

Hi,

i am new to alteryx and I have two problems to be solved in it.

1. I am working on one of the report and i need to perform the Vlookup with true (which is used in excel) can some help on this?

below is an example. 

2. also, i need to roundup values how can i achieve that in alteryx?

ex: 2.342 to 2.3 and 4.677777 to 4.7 etc...

many thanks for your help

lookup Table:

Level	Type
0	L1
1.01	L2
1.5	L3
2.4	L4

desired Result need:

Level	Type
0.2	L1
0.3	L1
0.2	L1
0.1	L1
0.2	L1
0.1	L1
0.4	L1
0.4	L1
0.3	L1
0.6	L1
1.3	L2
1.6	L3

Regards,

Shashank

[Bahouth12 · Accepted solution]

Hi @Shank,

I attached the solution for the two parts of your question and hope works fine.

Thanks

[Shank]

Thank you so much for the solution

[Shank]

Hi... Can we have same logic if we have multiple columns to lookup?

Ex

I need lookup one more column in source aprat from Type