Formula to autofill a field based on a code

[AndyRehn]

Hello,

So, I'm good at math based formulas but have no idea on logic/search/etc...

Here's what I want to do.

On sheet two I have two columns. Column A has codes (F9.1, L8.2, etc), column B has a sentence related to each code. On sheet one, I have an evaluation for my students. One of the fields is "observations". I would like to be able to put one of the codes into this box and have the sentence related to this code show up.

If anyone has ideas about how I can make this happen, please, let me know.

Thanks in advance.

[TMS]

That would be VLOOKUP ( for simplicity ) or INDEX/MATCH ( some would say, for efficiency )

Please Login or Register  to view this content.

where xxx is the cell reference you want to use for the search.

[AndyRehn]

Worked like a charm!

Thank you!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.