Copy value to another sheet based on criteria
Otk168
Posted messages
3
Status
Member
-
via55 Posted messages 14393 Registration date Status Member Last intervention -
via55 Posted messages 14393 Registration date Status Member Last intervention -
Hello everyone,
I am a beginner in Excel, trying to learn gradually both simple and complex formulas.
My problem is as follows:
My workbook consists of 2 sheets, the first contains a "database" with 2 columns (the first gives a reference and the second an associated code for that reference)
In the second sheet, there is a set of rows with a column containing the reference (from the first sheet).
I would like a formula that can fetch the associated code for each reference from page 1 and report it on page 2.
I hope I have been clear and explicit about this problem.
Thank you in advance for your help.
I am a beginner in Excel, trying to learn gradually both simple and complex formulas.
My problem is as follows:
My workbook consists of 2 sheets, the first contains a "database" with 2 columns (the first gives a reference and the second an associated code for that reference)
In the second sheet, there is a set of rows with a column containing the reference (from the first sheet).
I would like a formula that can fetch the associated code for each reference from page 1 and report it on page 2.
I hope I have been clear and explicit about this problem.
Thank you in advance for your help.
