How to include an if statement

Laydin

I have a vlookup formula. =VLOOKUP([Attribute Name]@row, {Standards List - Enhanced - Business Rules Range 1}, 4, false) . I need to be able to use this formula and check another column based on the version number. I need it to pull in x if it matches the name and version number.

Paul Newcome

Try this...

=INDEX(COLLECT({Column To Pull From}, {Name Column}, @cell = [Attribute Name]@row, {Version Number Column}, @cell = [Version Number]@row), 1)