If cell B10 = 1a, 1b or 1c then value in cell D10 should be x, y or z

[Mattock12]

I'll start by saying I'm useless with excel so my problem is likely to have an obvious solution!

I want to be able to bring data in from another worksheet if a cell in the main worksheet is equal to 1a, 1b or 1c

So data in main worksheet:
Column A
1a
1b
1c

I want to autopopulate Column B with the below descriptions if Column A = 1 a etc...

1a = No DT - Explain why these agenda points are important
1b = Q - Ask what other topics to include
1c = BFR - Ask what Saj thinks of this agenda

Make sense?

Any suggestions?


Thanks!!

[popipipo]

Use the function VLOOKUP
Something like this.
=vlookup(a1,mainsheet!a1:b3,2,0)

[Mattock12]

Ok, when I said my excel skills were poor, I really meant it....thank you so much for replying so quickly but could you explain the formua a little more please?

[popipipo]

Use F1 for a beter explanation then I can give you.

[Tony Valko]

See this:

http://contextures.com/xlFunctions02.html