hi, i wish to make a code whereby if part number (PN) is blank, it will refer to another excelworkbook sheet column c to multiply the catalogue price, while if there is a part number, it will refer to the other excel workbook column B to mulitply the catalogue price instead
here is the excel where it checks if column g (part number) is blank , if it is, it takes the catalogue price from column M to be multiplied by column C another sheet(user input)
if part number is not empty (there is a part number), value from column M is multiplied by column B of userinput sheet from another excel instead. the new value is to be replaced in total catalogue price in colmn N. it goes down the rows to complete thw whole sheet
hi
can you elaborate from which row it has to pic value on what criteria and do that sheet have column names
if possible provide screenshot of the other excel
fi you can attach the both sample files with expected output will get more insight
Regards
here is a screenshit of the userinput. need ot use column B if part number is not blnak, to be multiplied by catalogue price and output in total catalogue price, if partnumber is blank, we use column C instead
Hi,
I made a mockup based on your case. Let me know if my workflow helps.
Note: Somehow i couldnt upload the specific zip file, so i Uploaded all my files inside the folder here.
A.xlsx (7.8 KB)
B.xlsx (7.8 KB)
Main.xaml (11.7 KB)
project.json (1.5 KB)
Work sheet.xlsx (8.0 KB)
hii, i cant seem to open the UiPath, it shows internet explorer instead :((
nvm i gotit!! ill check it out thanks!!
