How to liks the row of 2 sheet

  • Thread starter Thread starter valeria
  • Start date Start date
V

valeria

Hi!!

I've an Excel sheet with

Cod Description (in 2 columns)
GG dsfdsfds
DD dfgfdgsd
AA fdgfdgsd
GG fgdfgdf


in another sheet I've:

Description (in a single column)
GG - Descrizione GG
DD - Descrizioen DD
AA - Descrizione AA



I would like to modify my first sheet like this:

Cod Description (in 2 columns)
GG - Descrizione GG dsfdsfds
DD - Descrizioen DD dfgfdgsd
AA - Descrizione fdgfdgsd


How Can I do this??


Thanks
 
Hi,

You need to use a vlookup formula.

In the third column of the second sheet, write this formula:

=vlookup(a1,sheet1!$a$1:$b$4,2,false)

This assumes that the you want to have the data from the first sheet
adjacent to column two in the second sheet. It also assumes that the
range/s of data are in cells a1:b4 on both sheets respectively.

Hope this helps!
 
Sorry I just re read the post.

You will need to extract the lookup information from from the single
column. To do this, use the formula below:

=vlookup(left(a1,2),sheet1!$a$1:$b$4,2,false)

This should work still - and it should matter which column you put it
into, so long as the a1 part of the formula refers to the first cell
of the lookup range, and the lookup criteria are two characters long.
 
Thanks for your reply but I don't know how to apply you solutions in my
excel fil :-((((

=vlookup(left(a1,2),sheet1!$a$1:$b$4,2,false)
I don't know how to apply the modify in the sheet1, using the detail
that I've in the sheet2

Could you send me an excel file with the example??

mail: thevalhallaATvirgilio.it

Thanks
 
Back
Top