Lookup from one list get data from two others

(0) Share

Report

Posted on by Dorinda

1,512

So I need lookup a value from one list to another match that value and return a yes no

This is the formula that is used in Excel

=IF('Pending Assessments'!T142<=(VLOOKUP('Pending Assessments'!Q142,'Family Size Income Table'!$A$3:$B$10,2)),"Yes","No")

Here is my attempt that didn't work in PowerApps

LookUp('Family Size Income',Text(Title=DataCardValue68.Text) & Text('150ofPoverty'=DataCardValue70.Text))

Any help would be appreciated.

Categories:

I have the same question (0)

All responses (1)

Answers (1)