Hello all.
I have the following situation:
I have some values in column A.
other values in column B.
I want to be able to display a list using the values in column A and values in column B.
A1-> B1, etc..
Attach file:
Book2.xlsx
Hello all.
I have the following situation:
I have some values in column A.
other values in column B.
I want to be able to display a list using the values in column A and values in column B.
A1-> B1, etc..
Attach file:
Book2.xlsx
If you mean it by concatenating the A1 and B1, try the below formula......
=A1&" -> "&B1
If this is not what you want, please explain what do you want exactly.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
I want to be able to select from a list of values in column A and in a cell to display the values in column B.
If the select list is 80 - as in the attachment - then be displayed value Ø88, 9, if I select for example 350 to display the value Ø355 etc .. etc
Please find the attached sheet to see if this is what you want.
sktneer thxxxxxx ..is perfect!!!
Glad to help you. Thanks for the feedback.
If you have got the answer, please mark your thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks