Thread: how do i do this ?

if i have 2 columns with different information in them how do i merge the
two to become one column with all the information in?
i'm trying to use vlookup to search a list of equipment (column B) and give
me the figure in the box next to it (column C) but some of the info i need
to find it is in the first column (column A) so i would like to merge the 2
together . (A+B)

hope this makes sense ?

thanks for your help

Phil

If I understood your question correctly, I believe what you need to do is in
column c you need to put =sum(column A + column B)
This will give you the sum in column C

"phil" wrote:

> if i have 2 columns with different information in them how do i merge the
> two to become one column with all the information in?
> i'm trying to use vlookup to search a list of equipment (column B) and give
> me the figure in the box next to it (column C) but some of the info i need
> to find it is in the first column (column A) so i would like to merge the 2
> together . (A+B)
>
> hope this makes sense ?
>
> thanks for your help
>
> Phil
>
>
>

sorry, i mustn't have explained properly.
column a and b have different text in. i would like to make the text all
together i one column?


"Christine Lombardo" <ChristineLombardo@discussions.microsoft.com> wrote in
message news:B6ECE90F-0CEB-40FB-B923-6A411E44B8D5@microsoft.com...
> If I understood your question correctly, I believe what you need to do is
> in
> column c you need to put =sum(column A + column B)
> This will give you the sum in column C
>
> "phil" wrote:
>
>> if i have 2 columns with different information in them how do i merge the
>> two to become one column with all the information in?
>> i'm trying to use vlookup to search a list of equipment (column B) and
>> give
>> me the figure in the box next to it (column C) but some of the info i
>> need
>> to find it is in the first column (column A) so i would like to merge the
>> 2
>> together . (A+B)
>>
>> hope this makes sense ?
>>
>> thanks for your help
>>
>> Phil
>>
>>
>>