Pulling in values from another sheet

Hi Matthijs,

The syntax with INDEX, MATCH is tricky.

Most people think it's INDEX(MATCH) but it's not

IT's really INDEX,MATCH

This is the syntax from the INDEX pop-up:

=INDEX(range, row_index, column_index)

We're not using the column index. Only the row index.

The MATCH is the row index. It looks for the contract number & sends back the row number

I just did a test with 2 sheets and here's the basic formula:

=INDEX({Sheet2-Vendor}, MATCH([Contract Number]@row, {Sheet2 Contract}, 0))

Note the curly braces are the range from {Sheet2}. You can't just type them in, you have to create the range from within the INDEX formula pop-up window.

In the example, my cursor is in the [Vendor] column. Note the yellow highlight. Now you need to click the "Edit Reference" hyperlink to make a link to {Sheet 2}

I named the ranges to make our example clearer - {Sheet2-Vendor} and {Sheet2-Contract} and {Sheet2-Manager}

Here's the results with Vendor AND Contract Manager brought back from {Sheet 2}

Note the small blue triangles showing inbound data

Hope this helps,

Mark V

Great to hear Matthijs. Continue to reach out! Some great people on here.