How to search specific cell value from excel to get respective cell value

Help Activities
, ,
1

final_output_data.xlsx (12.5 KB)

hi every one,
here from the backend I get the Invoice number, I Have to search that value in first column and want the data of column e.
eg. if I get this value from backend “32074” than I have to search in column 1(“Invoice”) and get the respectively column value from column e (“pdffilename”) .

output be, 360 SHS _Aug-21_32074
Can some one help me.

2

Hi @ashishmani

This can be done by Lookup datatable.

image
image984×490 30.1 KB

Regards
Sudharsan

3

I have to pass particular value of to column a then want respective value from column e,
the value which I have to search are coming in a variable.

4

image
image1920×1080 226 KB

got null value

5

Hi @ashishmani

May be this is because of the blank line inside your input
Remove that and try once again
image

Regards
Sudharsan

6

still get null value.
final_output_data.xlsx (12.5 KB)
test.xaml (24.0 KB)

7

HI @ashishmani

Change the invoice number column format as number and use the same flow
Note : you can search only one by one don’t give multiple values
Regards
Sudharsan

8

Here is the screenshot
image

Regards
Sudharsan

9

can you send the xmal, because i dont know where i make the mistake.

10

You can try this alternative use Lookup Range here is the sample flow

Sequence1.xaml (7.8 KB)

Steps will

  • Read Range
  • LookupRange store in a variable
  • read cell in the particular cell by giving dynamic range and store the value

Regards
Sudharsan

1 Like
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.