Unable to perform Vlookup

Help Activities
, ,
1

Hi All,

Good Morning.

I am trying to perform Vlookup functionality between two excel sheet based on a unique column (Set_ID) from sheet 1 and (Set_ID) from sheet 2 whatever the matched value to be written in sheet 1(Column R), I am trying but I am getting an error like as in the attachment.
Please someone do needful to resolve the issue.

Screenshot (2)
Screenshot (2)1366Ă—768 102 KB

2

@HeartCatcher

It’s showing error like mentioned column name is Invalid. Can you please recheck the column name. It should be exactly match and case sensitive. Else you can pass column index.

3

I Did as you said even after I am getting the same

4

Hi @HeartCatcher

Could you please share the excel sheet you are referring,from the error it shows there is a problem with “SET_ID” , please check if matching with the excel column name.

Thanks

5

Spice Money Payments_SEP333’21.xlsx (152.3 KB)
The Set_ID which is under Column “Q” is unique ID.

With the Row Label which is under A column is unique ID in sheet 2.(Trail_Balance excel)
Trail_Balance.xlsx (22.6 KB)

Please do needful.

Thanks.

6

Instead of writing the column name mention column index (row(your_column index).To strong)

Thanks & Regards
NaNi

1 Like
7

I tried but getting the same error

8

I saw the excel file and in spice money excel the actual headers are starting from 4th row, that’s why you are getting the error it consider first row as header and it does not contain “set_id”

Delete first 3 rows in the spice money excel and try again

Thanks

9

Thanks for the reply for calculation purpose I need first 3 columns so I shouldn’t delete that.
So I am reading the excel from “A4”

1 Like
10

please can you send me the work file?

Thanks&Regards
NaNi

11

Hey I can see that your column name (SET ID) but you mentioned (SET_ID). once check this. if still getting the same error please send me your workflow.

Thanks & Regards
NaNi

12

Vlookup.xaml (10.8 KB)
Please find the work flow

13

@ppr Can you please help me on this

15

@HeartCatcher Have you tried it?

Thanks

16

Yes I tried I am getting an error as in the attavhment.

Screenshot (5)
Screenshot (5)1366Ă—768 104 KB

17

@HeartCatcher could you please share some more screenshots of the workflow.

Thanks

18

Screenshot (8)
Screenshot (8)1366Ă—768 90.7 KB

Screenshot (9)
Screenshot (9)1366Ă—768 92.5 KB

Screenshot (10)
Screenshot (10)1366Ă—768 97.8 KB

Please find

19

@HeartCatcher

Please try below steps,

  1. The first read range for trial file is okay we dont need to change it.

  2. In second excel application scope’s (for spice file) read range give range as “”

  3. After the read range, again put a read range and give range as “A4:S” + Recon_file.rows.count.tostring

  4. In get row item you have selected index and not gave the index number, instead of selecting the index select name and give “SET ID”

  5. In lookup datatable give value as set_id.tostring

Thanks

20

Hi @HeartCatcher ,

Can you please try with Join Data Tables Activity. I think if you use Inner join then you should get common values from both Data tables.

Regards,
Vijay.

1 Like
21

Can you explain a bit how to do that please.