Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
4 years ago

Issue with Lookupvalue Formula

Hello,   am trying to get value from Table1 to Table2 where I used below lookupvalue formula but am getting Not Found as value is available in Table1. I tried two formula(as below) but getting sam...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Chandrashekar 
Can you please provide sample data and advise the relationship between the two tables?

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
4 years ago

Hello,

I have established relationship on date field. Table1 have unique value(Number) however Table2 have duplicate value(Number).

Unfortunately I cannot share file as it confidential but I copied few records(10 rows) in another table and it is working fine but for huge data(12K) it is not working.

 

Regards,

Chandrashekar B