| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching Data
Hi
I have two sheets in a single workbook I want to look up where data in sheet 1 Column A matches the data and sheet 2 Column A and where there is a match bring the relevant data from Sheet 2 Column H and place it into Column H on Sheet 1. I think this is a Lookup, but cannot get the syntax right. Any help much appreciated thanks Alex |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching Data
In cell H1 on Sheet 1 put the following formula, adjusting the lookup range
accordingly and then copy down =VLOOKUP(A1,'Sheet 2'!A1:H200,8,FALSE) "Alex Hammerstein" wrote: Hi I have two sheets in a single workbook I want to look up where data in sheet 1 Column A matches the data and sheet 2 Column A and where there is a match bring the relevant data from Sheet 2 Column H and place it into Column H on Sheet 1. I think this is a Lookup, but cannot get the syntax right. Any help much appreciated thanks Alex . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter Data on one tab, then find matching data on another tab | Excel Worksheet Functions | |||
| Matching a column of new data to existing larger data set. | Excel Worksheet Functions | |||
| Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
| Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Linear Mode
