Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in columns by matching a value on another sheet
I have a large spreadsheet with information that I need to copy over to a
newsheet. I need to pull location information out of a specific cell on the first sheet and put it in a cell in a column on the second sheet in the row that corresponds to the matching account number. for example on sheet1 I have: Column A Coulumn B 12345 New York and on sheet2 I have: Column A Column Z 12345 and in column Z I want to have Excel copy 'New York' from the first sheet. This is what i have tried without luck: =IF(COUNTIF(Sheet1!$B$2:$B$404,Sheet2!B6)0,Offset (MATCH(B6,Sheet1!$B$2:$B$404),0,11),"") any help is greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in columns by matching a value on another sheet
=VLOOKUP(A1,Sheet1!A1:B100,2,FALSE)
of course the 100 can be changed to match your needs. -- Gary''s Student - gsnu200800 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in columns by matching a value on another sheet
Have you tried vlookup?
"Xhawk57" wrote: I have a large spreadsheet with information that I need to copy over to a newsheet. I need to pull location information out of a specific cell on the first sheet and put it in a cell in a column on the second sheet in the row that corresponds to the matching account number. for example on sheet1 I have: Column A Coulumn B 12345 New York and on sheet2 I have: Column A Column Z 12345 and in column Z I want to have Excel copy 'New York' from the first sheet. This is what i have tried without luck: =IF(COUNTIF(Sheet1!$B$2:$B$404,Sheet2!B6)0,Offset (MATCH(B6,Sheet1!$B$2:$B$404),0,11),"") any help is greatly appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in columns by matching a value on another sheet
Worked like a charm! Thnaks for the reminder that everything doesn't have to
be as complicated as I make it. "Gary''s Student" wrote: =VLOOKUP(A1,Sheet1!A1:B100,2,FALSE) of course the 100 can be changed to match your needs. -- Gary''s Student - gsnu200800 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching Columns | Setting up and Configuration of Excel | |||
Matching 2 columns | Excel Worksheet Functions | |||
matching on columns | Excel Discussion (Misc queries) | |||
MATCHING COLUMNS | Excel Discussion (Misc queries) | |||
List matching data from sheet 1 in sheet 2 | Excel Worksheet Functions |