0

I would like to ask if there is a solution to my problem:

I have 200 numbers from 1 to 200 which are linked with text. For example: 1 = car, 2 = bicycle and so on. I would like to write a number (1) in the A2 cell and I would like to automatically get the text (car) into the cell B2. Is there some formula for this?

  • Yep, you just described the very purpose of VLOOKUP :) would need to see exactly how your data was arranged to give an exact formula. – sageco Feb 5 at 11:46
  • Yeah, VLOOKUP is perfect for me :) Thanks for help :) – Máté Góra Feb 5 at 23:00
0

=ARRAYFORMULA(IFERROR(VLOOKUP(A2:A, Sheet2!D2:E, 2, 1), ))

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.