How to get information via a file.

[Klomas]

Hello excelforum,

I can program websites a little bit. But unfortunately Excel is a completely different thing. So:

Can anyone tell me how to take information from a cel in one tab and change the value through information from another tab.
For example:
I want to take the value "LMG" from the tab "roster" to go to A1 in tab3. But I don't want it to say "LMG". I want it so say "Leven met God" which is the information that can be found in the tab "list".

Example.jpg

Please me help me out. All help is really appreciated.

Greets

Klomas

PS I included a picture for clearification.

[AlKey]

Try this formula:

=IF(roster!A2="LMG","Leven met God","")

Assuming LMG is in cell A2 on sheet named roster

[Klomas]

Thank you for your fast reply AlKey. The problem is though that I want to be able to change the value LMG in Roster so that is wil change at the same time in tab3.
If I would change the value to MED, it should (you can see this in list) say: Meditatieviering.

[AlKey]

Ok, I see what you saying

You can use VLOOKUP function for this

this assumes that look up value located in cell A1 and you need to retrieve data from column B on roster sheet.

=IFERROR(VLOOKUP(A1,roster!$A$1:$B$60,2,0),"")

[Klomas]

I don't think I understand. How can tab3-A1 know what the abbreviation LMG or MED means if I don't take that information out of the tab named list?

[AlKey]

I think I have failed to make it clear that formulas in excel do not change the content of the cell. They can only manipulate data in order to get results.