LinkedIn
Twitter
I have two tables. One I need to search in to find a certain string and/or column.
I have tried using - Contains(), IN() and LOOKUP(), but have failed. In the screen shot you can see I have a dash set up with views/tables. Table A has column [equipment]. Table B has column [item List]. I want Table A to search table B to make sure that [equipment] is IN column [Item List]. I also want Table B to search Table A to do the same thing. I seem to have Table A working correctly, it formats the row to "Green". Table B, I cannot get correct.
