Lookup formula still available?

Wayne Kung

Hi there!

Is the Lookup formula still usable in Smartsheet? I'm trying to do a lookup within a matrix of values, where I need to specify both a horizontal and vertical lookup criteria. From what I've found, it looks like Lookup would've been able to do it, but it doesn't look like that formula exists in Smartsheet now.

Thanks!!

Paul Newcome

VLOOKUP still exists, but I would suggest more of an INDEX/MATCH or INDEX/COLLECT depending on your exact setup.

Wayne Kung

https://community.smartsheet.com/discussion/comment/305397#Comment_305397

Thanks! I've tried both INDEX/COLLECT and INDEX/MATCH, but the part that i get stuck is that I need to be able to look up a value using both a horizontal and vertical identifier. I created a quick sample set of data similar to what I'm working with - basically, I'm looking for a value based on the flavour (column on the left) and the Store number list across the top. eg. If the parameters were to look for the quantity at Store 2 for Premium, it would return 32.

Paul Newcome

Then you would want an INDEX/MATCH/MATCH

=INDEX({Table of Data to Pull}, MATCH(Flavour@row, {Table Left Column}, 0), MATCH([Store Number]@row, {Table Top Row}, 0))

Wayne Kung

https://community.smartsheet.com/discussion/comment/305495#Comment_305495

YES!!!!!! That did it!! Thank you!!!!!!

Paul Newcome

Happy to help. 👍️