No Value being returned

CaitlinGhost

Hi there, I'm trying to pull information from one sheet to another using INDEX Match. The formula has worked for one row, but for other rows it isn't returning a value.

The formula I've used is:

Screenshot 2024-07-16 141241.png

=INDEX({2025 Bid Funding Data Sheet Range 3}, MATCH(Customer@row, {2025 Bid Funding Data Sheet Range 11}, 0))

=Chris Palmer

Hi @CaitlinGhost,

I suspect the INDEX from the Customer@row on your reference sheet is blank, thus giving you a blank result.

Brian_Richardson

Without knowing what those references point to, it's hard to say. As @Mr. Chris said, it looks like you simply don't have values to pull in. Check your references to ensure they are selected for the entire column. I would reselect the column for each reference just to be sure, sometimes Smartsheet can behave oddly and forget the column reference.

Another gotcha is sometimes the criteria (Customer@row) is in text or number format, and the range you're searching (Range 11) is in the opposite criteria, or is a mix of formats. Match will only match numbers to numbers, and text to text.

Other than that, your formula looks like it's constructed correctly.