How to get value a field based on of two other columns?

J

jamal ZETAWI

How to get value a field based on of two other columns?
Case:
If the first value in the first column is 23 and the corresponding value in
the next column is AA, I need the corresponding value in the third column to
be 23AA, how to get this result?

Thank you
 
T

Trekman

How to get value a field based on of two other columns?
Case:
If the first value in the first column is 23 and the corresponding value in
the next column is AA, I need the corresponding value in the third columnto
be 23AA, how to get this result?

Thank you
Click to expand...

using A1 and B1 ... this formula woks: =(A1&B1)
note the sign is an ampersand, not a "+" ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returnig a value 6
how to get value from a table satisfying two conditions 2
Finding Corresponding Cell Value 2
Look up two values in different columns and return matching value 5
How to use vlookup in an array formula 2
Need Help 4
Looking Up Only <>"" 2
Index / Match / value in a range? 2

Top