Returning Data with a formula

Debbie Petersen

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

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))