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>
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]456[/TD]
[TD="align: right"]789[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
</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>
123 | |||
123 | |||
123 | |||
John | |||
Jeff | |||
Martin | |||
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]456[/TD]
[TD="align: right"]789[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
</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?!