I've tried using both: =A1&""&B1&""&C1 (also without the "") and =CONCATENATE(A1,B1,C1)
However when referencing them in a simple lookup formula it gives an incorrect output.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
The top left are the 3 methods I know of combining 3 cells into 1. The #N/A formula references each one individually: =lookup(D1,A4:B6)
The answer I am looking for here is John, yet in the actual spreadsheet I am getting the bottom-most value in the 2nd column every time, in the example I typed out above I am just getting #N/A Error Did not find value '123' in LOOKUP evaluation.
Any ideas please?!
However when referencing them in a simple lookup formula it gives an incorrect output.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
1 | 2 | 3 | 123 |
123 | |||
123 | |||
123 | John | ||
456 | Jeff | ||
789 | Martin | ||
#N/A | #N/A | #N/A |
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
The top left are the 3 methods I know of combining 3 cells into 1. The #N/A formula references each one individually: =lookup(D1,A4:B6)
The answer I am looking for here is John, yet in the actual spreadsheet I am getting the bottom-most value in the 2nd column every time, in the example I typed out above I am just getting #N/A Error Did not find value '123' in LOOKUP evaluation.
Any ideas please?!