How to assign a value to a cell containing text Solved

Question

Hello,I would like to know if it is possible to assign a value to a cell containing text. I would like to create a scorecard to exploit the qualitative data from my table by translating it into quantitative data.Thank you for your help,KarineConfiguration: Windows / Chrome 51.0.2704.79

kessya2002 · Accepted Answer

Thank you very much, I managed without any problem, it helped me progress in my project! I wish you both an excellent day, that's great! See you soon, I will surely have more requests.

Vaucluse · Answer

Hello everything is possible... or almost, but if you can tell us more about your data, we will respond without any problem  Example: sheet1 database with a list of reference texts in A and their corresponding values in Bsheet2 your texts to "grade" starting in A1 from 1: =VLOOKUP(A1,Sheet1!A:B,2,0) will give you the value from the database table that corresponds to the text Looking forward to hearing from you best regards    -- The quality of the response mainly depends on the clarity of the question, thank you!

kessya2002 · Answer

Thank you for your quick response. Actually, I created a table with different columns in which I inserted choice lists. I would like to assign a value based on the selected choice in the list. For example: G4 has a choice list "Yes", I would like to assign the value 0 and "No" the value 1, all on the same spreadsheet. Thank you.

The_boss_68 · Answer

=CHOISIR(EQUIV(G4;{"oui";"non"};0);0;1)

Comment affecter une valeur à une cellule contenant du texte

4 answers

=CHOISIR(EQUIV(G4;{"oui";"non"};0);0;1)

Jbl 500 bt one-sided issue.

Remove youtube from freebox pop apps

Subliminal image in a video

I'm looking for java or jar game sites.

How to unsubscribe from jm plan cul

Edit ad on leboncoin for free

Commun.file_upload.maxsize

Problem opening modal window from another page

Thursday modification test title number 3

How to change sources on a grundig universal remote?