Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am having trouble with this and cant figure it out. Sorry if I dont explain this correctly but here it goes.

I have 2 sheets. Sheet1 column A has a list of names that need to be matched against the same set of names listed on sheet 3 column A. When a match is made I would like to be able to have TRUE or FALSE return a different name that I can change.

please let me know if the description is not enough

share|improve this question
The matching bit is fine; that sounds like either VLOOKUP, INDEX or MATCH. The line "return a different name I can change" I'm struggling to get. Can you expand your problem? – Gary Nov 27 '12 at 13:26
@Gary: I too don't know what exaclty he wants. Without further explanations, we aren't able to help. – nixda Dec 29 '12 at 9:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.