No Value being returned
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:
=INDEX({2025 Bid Funding Data Sheet Range 3}, MATCH(Customer@row, {2025 Bid Funding Data Sheet Range 11}, 0))
Answers
-
Hi @CaitlinGhost,
I suspect the INDEX from the Customer@row on your reference sheet is blank, thus giving you a blank result. -
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!