vlookup i think?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jono - 05 May 2008 12:39 GMT

i have 2 spreadsheets, with similar data. one sheet has invoice and cost
centre and the newer sheet just has the invoice number. i need to compare and
assign cost centre code to the invoice numbers in the 2nd sheet.

Reply to this Message

Mike H - 05 May 2008 13:27 GMT

Hi,

Lets say sheet 1 looks like this

inv    Cost centre
1    10
2    11
3    12
4    1
5    3
6    155
7    123
8    134
9    176

and sheet 2 looks like this

inv Cost Centre
1
2
3
4
5
6
7
8
9

Put this in b2 of sheet 2 and drag down

=VLOOKUP(A2,Sheet1!$A$2:$B$10,2,FALSE)

Mike

> i have 2 spreadsheets, with similar data. one sheet has invoice and cost
> centre and the newer sheet just has the invoice number. i need to compare and
> assign cost centre code to the invoice numbers in the 2nd sheet.

Reply to this Message