Multiple lookups


I want to use multiple lookups if data matches in three columns then 4th column should be subtracted Please help

Hi @abhide ,

Check this sample workflow & modify as per your requirement.

Workflow:
Compare_Columns.zip (3.2 KB)

1 Like


image


go through the below topic

regards
Chethan P

1 Like

Hi Chetan thanks for your input can you show me what’s inside the look up data table and also inside assign activities please.

1 Like

Hi Shraddha thanks for the inputs but i when i download the workflow it is showing errors. can you help me please

I share the link of the topic you can go through it you will get the zip file of the project

If you get the solution please mark it as solved

Regards
Chethan P

Ok let me look in to it thanks


Should i install some packages i dont know why i am getting such error

yes go to project in Bellow of activity panel you just update or repair the package.


I still have one error any idea how to solve this

FormQuestion1.zip (11.7 KB)
I hope this is helps to you

If you get the Solution MARK IT AS SOLUTION

regards
Chethan P

1 Like


I dont know why i am getting this error I have installed all the required packages suggested

Ok i will provide the screenshoot

1 Like

image




image
image
bellow i show what is the inside of the Lookup data table


Hear number is where you want to add or target the column name
image
this is second LookUp data table
image
Hear in the below i use dt3 means third data table sheet no 3 ok and save it in opDT3
Hear am Using Column Index is o i target name ok
column index 1 is target number column

image
image
CInt(Row1(1))+CInt(OpDT2)+Cint(OpDT3)

make Shure the variable type

image
Hear am save total into row(1) why means i have to print in another sheet4 soo
row(1) is for each
image

last One is
Out side of the for each use write range
image

I hop you under stand the project

If you get the solution please mark it as solution and close this thread

Regards
Chethan P

2 Likes

Let me run this and get back to you. Thanks a lot for your timely feedback

1 Like

Its ok no problem fell free if u get any dought ask

regards
happy automation

1 Like

ss2


Hi chetan in the program you mentioned it looks only for bread, sausage in column A. but i want to see if it matches all three (column A,B,C) city item and material then only difference should happen


I guess this will look only after city and will not look after item and material

Hi @abhide ,

Please refer following screenshots:

1 Like

Thanks shraddha let me try this