You could use VLOOKUP function.

Example:- Assuming that the first spreadsheet is sheet 1 and the CMDB dump
is sheet 2 with the asset Id in column A in each case.

Your formula in column C would be something like this

=VLOOKUP(A2,Sheet2!$A$2:$D$30,3,FALSE)

The following is a description of the formula:-

VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

You can get more information in help but here is a little to go with it.

Lookup_value is your Id number.

table_array is the range to lookup on sheet 2. Note that this range is in
absolute format. That is it has $ signs in front of both the column and row
so that the lookup range will not alter as you copy the formula down the
column. Also the column in which vlookup expects to find the match must be
the first column of this array.

col_index is the number of the column in the array to get the data to put
into where the formula is. In the above it is column C which is the third
column.

false says to only accept exact matches.

Regards,

OssieMac






"Jeffa" wrote:

Hello,

I hope you guys can help me, I've had this issue that I'm dying to solve!.

I have a spreadsheet that has around 15 colums, each line has unique
information about a pc/laptop.. For example

Col A: Asset Id number
Col B: Description
Col C: SMS Last update
Col D: Primary User

Now, in another spreadsheet, which is a direct dump from our CMDB I have a
similar setup where you have

Col A: Asset Id number
Col B: SMS Last update
Col C: Primary User

I would like this second spreadsheet to update the associated SMS update and
primary user update..

So it would search the second workbook and go, ok so Col A in the first
sheet is W1125021 and Col A in the second workbook is W1125021, what is
column B's data in the second sheet, ok, I'll put that in column C's data in
the first wookbook.

Hope you can help, and I hope this was understandable..