Is there a formula to get values from B1 if A1 is blank?
I want a formula that will return with the value of cell A1 but if cell A1 is blank, then it will look at the value in B1 and Then I want to do an Index match to a different reference.
This is what I have so far:
=INDEX({Equipment Master Range 3}, MATCH([Asset Number]@row, {Equipment Master Range 4}, 0))
Answers

The syntax would be something like:
=IF(ISBLANK(A1), The Index/Match formula for B1 goes here, The Index/Match formula for A1 goes here)
Does the logic make sense? IF the A1 cell is blank, use the Index/match for B1, otherwise, use the Index/Match for A1.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!