Formula help: if two cells match on different sheets, display value of adjacent cell... - Microsoft Community Hub
![I want to display data from table 2 in table 1, but only if the data in table 3 with the same header has a specified value. Is this an XLOOPUP with I want to display data from table 2 in table 1, but only if the data in table 3 with the same header has a specified value. Is this an XLOOPUP with](https://preview.redd.it/i-want-to-display-data-from-table-2-in-table-1-but-only-if-v0-r1hd485vn7x91.png?width=1920&format=png&auto=webp&s=4a64fce3b6d52a3daf2feec3d08bbf4aa850e0eb)
I want to display data from table 2 in table 1, but only if the data in table 3 with the same header has a specified value. Is this an XLOOPUP with
![worksheet function - Excel Formula - Cell equals contents of another cell but display blank if the cell was empty - Super User worksheet function - Excel Formula - Cell equals contents of another cell but display blank if the cell was empty - Super User](https://i.stack.imgur.com/EkkTk.jpg)