Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement
Probably just late in the evening but am trying to capture an adjacent column
to a unique identifier from another worksheet and populate in the original worksheet. The first worksheet may have duplicate entries but all rows would need to bring back information e.g. Worksheet 1 : Column A 12345 12345 15432 14325 Worksheet 2 : Column A Column B 12345 Bananas 12432 Apples 15325 Pears Worksheet 1 after add function : 12345 Bananas 12345 Bananas 12432 Apples 15325 Pears Anything simple would be good although in the future likely to be pulling back several cells of information adjacent and unique to the identifier. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement
Try this:
=VLOOKUP(A1,Sheet2!A$1:B$100,2,0) Copy down as needed -- Biff Microsoft Excel MVP "WT" wrote in message ... Probably just late in the evening but am trying to capture an adjacent column to a unique identifier from another worksheet and populate in the original worksheet. The first worksheet may have duplicate entries but all rows would need to bring back information e.g. Worksheet 1 : Column A 12345 12345 15432 14325 Worksheet 2 : Column A Column B 12345 Bananas 12432 Apples 15325 Pears Worksheet 1 after add function : 12345 Bananas 12345 Bananas 12432 Apples 15325 Pears Anything simple would be good although in the future likely to be pulling back several cells of information adjacent and unique to the identifier. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement
You could try VLOOKUP - as you have not given any ranges for your
data, I've used full-column references: =VLOOKUP(A1,Sheet2!A:B,2,0) and copy down as required. If you are likely to have more columns in future, you could try this: =VLOOKUP($A1,Sheet2!$A:$F,COLUMN(B1),0) and then you could copy this across (to column F maximum) - the COLUMN parameter will adjust automatically to give you 2, 3, 4 etc. Hope this helps. Pete On Nov 3, 6:45*pm, WT wrote: Probably just late in the evening but am trying to capture an adjacent column to a unique identifier from another worksheet and populate in the original worksheet. *The first worksheet may have duplicate entries but all rows would need to bring back information e.g. Worksheet 1 : Column A 12345 12345 15432 14325 Worksheet 2 : Column A Column B 12345 Bananas 12432 Apples 15325 Pears Worksheet 1 after add function : 12345 Bananas 12345 Bananas 12432 Apples 15325 Pears Anything simple would be good although in the future likely to be pulling back several cells of information adjacent and unique to the identifier. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |