Returning Data with a formula

Boy have I gone round and round with this! This formula is meant to bring back the data from another sheet based on the code entered (ie: code - CALVE and it should return the full name, email of that company from a different sheet). Sometimes this formula works perfect and other times it brings back the wrong company? Can NOT figure this out? Anyone see the problem here in this formula?

=INDEX({Sub Company}, MATCH(Code@row, {Sub Code}, 1))

TIA!

Debbie

Find more posts tagged with

Construction

Formulas

Comments

Andrée Starå

Hi Debbie,

I'd be happy to take a look!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday

Have you considered using VLOOKUP to do the same thing?

https://help.smartsheet.com/function/vlookup

Paul Newcome

Try swapping the 1 in the MATCH portion with a 0. The 0 will look for an exact match to the Code@row as opposed to just something close.

=INDEX({Sub Company}, MATCH(Code@row, {Sub Code}, 0))

Sign in to join the conversation!

Quick Links

Trending discussions

Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet