Problem with LOOKUP Formula

[waltonad0283]

Hi All,

I have a spreadsheet I have been working on and having some difficulties with it.

What I am trying to do:

In Sheet 1:
There is a table of devices (by name) and command names. (This works! because of help from this forum!) Now, I want to go back in an add a "Command Type" Column.

In Sheet 2:

Generate a Concatenated string that uses a value in a column to match to the first sheet.

Essentially - in sheet 2, it does a look up based on a display name (IE LG) it then looks to see in Sheet 1, what LG's command type is, and then matches to the command name and inserts a number (from the spread sheet).

I thought I had this working by adding a lookup formula: =LOOKUP([@Display],SerialCommands[Display],SerialCommands[Command Type])

This seems to work for some of the displays, but not all of them - but's it's not the range as one of the devices it doesn't work for is in the middle of the range.

Can someone help point me in the right direction on why this isn't working?

Spreadsheet attached, and I GREATLY appreciate the help!

[mrice]

if you data on the first tab is sorted by the display, it seems to work. This suggests that you need to include the FALSE argument added to you nested functions to stop them assuming that the lookup data is sorted alphabetically.