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.https://www.linkedin.com/in/zchrispalmer/
-
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
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!