Thread: Matching Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alex Hammerstein Alex Hammerstein is offline
external usenet poster
 
Posts: 4
Default 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