Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to perform the following function:
compare column a in sheet1 with column a in sheet2, if there is a match then I want to pull the values from sheet 1 column b and c to the corresponding row in sheet2. For instance on sheet1, cell a2 is abcd, b2 is 12345 anc c2 is 54321, on sheet 2 cell a12 is abcd. So I would like to pull b2 and c2 from sheet 1 to sheet 2 in cells b12 and c12. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |