To get cell postion

Help Studio
, , , , , , , , ,
1

Hello everyone,

How can we get the cell value by comparing these two fields in excel
Example

Year|Month|ORG_N90|ORG_N80
2023|1 |80 |

So it needs to check what the cell value of 80
By checking which row 2023 and 1 is present
For column ORG_N90

2

Hi @anmita

If you want to get the row index you can use Lookupdatatable

If you want to get the cell position in excel like it is cell C2
you can use Lookup range

Regards
Sudharsan

3

Hi Sudarshan,

Thanks for the response

But my question was that we have two fields in a row and we need to find the cell value of code field
So C4 Cell Value we should get after it has checked

c4
c4756×267 8.37 KB

Have attached the file for reference
Amt (2).xlsx (5.3 KB)