This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello, I have data in the following format
| Gender_1 | Gender_2 |
|---|---|
| Man | NA |
| NA | Woman |
| NA | Man |
| Woman | NA |
I wish to replace the NA in gender_1 with the corresponding Woman, Man in Gender_2, is there a formula to perform this task? The original dataset has 100s of such entries.
| Gender_1 | Gender_2 |
|---|---|
| Man | NA |
| Woman | Woman |
| Man | Man |
| Woman | NA |
Thank you!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
You can not use a formula in a cell to replace the value based on that cell value itself.
You can however enter this in C1, assuming you have your data in Col A and B
=IF(A2="NA",B2,A2)
and copy down.
You can then copy values in Col C and PASTE SPECIAL -> AS VALUES over values in Col A
Result
Thank you!