nested if and offset formula from dropdown list

[abrazee]

I have two lists ("fulllist" & "code" - A1:A20 is a data validated dropdown list of "fulllist". I want B2:B20 to return a list item offset one column to the item selected in A1:20

So, if A:1 drop down equals "asphalt paving" I want B:2 to insert a code from a list on cell right of asphalt paving.

Something like =IF(B31<>"fulllist",=OFFSET("fulllist",0,1,,),"") This returns an error. I have a feeling I need to use match. I can't seem to find an answer to this and I bet it is fairly simple.

[ChemistB]

Assuming that "FullList" has only unique values (Yes?)

Let's say Fulllist is in Sheet2!A1:A100
In B1 (sheet1)
=INDEX(Sheet2!$B$1:$B$100, MATCH(A1, FullList,0))
Does that work for you?

[abrazee]

yes...thanks