Forum Discussion
Solved
Add New Column to Table using 2 IF Statements...
Hi There, I been trying to find the answer to this with no luck and I know I'm just overlooking the obvious. My 2 tables look like this Table 1
ID Project Status
1 Build Pending
2 Walk Comp...
Hello Dexter1088
You can pull the value over using the following as a calculated column in Table2.
Status Lookup = LOOKUPVALUE(Table1[Status],Table1[ID],Table2[ID],Table1[Project],Table2[Project])
You could also create a calculated column in both Table1 and Table2 that combines ID and Project into a single field an join the two tables on that.
Hello Dexter1088
You can pull the value over using the following as a calculated column in Table2.
Status Lookup = LOOKUPVALUE(Table1[Status],Table1[ID],Table2[ID],Table1[Project],Table2[Project])
You could also create a calculated column in both Table1 and Table2 that combines ID and Project into a single field an join the two tables on that.
works perfect!
I was trying the same thing just had my tables out of order. Thanks!
