Relationship between work sheets

Hi All,

I'm a novice when it comes to excel, have a little knowlege but on this forum I accept my limitations. However I hope that yee can help me.

I have two work sheets, one is used to print a cover sheet to be attached to an invoices that will be sent to accounts for payment, the second work sheet has a list of all our supplier names.

I want to be able to key in the account reference code on the Sheet one and other such as Name and VAT number will automatically come accross form sheet two based on teh account reference code.

Thanks

Boatman

Sounds like you want a VLOOKUP() or the reliable INDEX(MATCH()) combo.

They'd work like this:

1) VLOOKUP(sheet1!acc_ref_code, sheet2!value_matrix, offset_from_left, FALSE)

And the offset from the left would change for the Name and VAT depending on which is second or third column in the matrix (account reference number would be first column).

2) INDEX(sheet2!value_array, MATCH(sheet1!acc_ref_code, sheet1!acc_ref_code_array, 0))

And the sheet2!value_array would be whatever column the particular values (Name or VAT) you are looking for... note this requires that the reference codes, Names, and VAT all be the same size, sorted in the same order.

Anyway, if you want more specifics, plz post example worksheet.