Thread: search value in 2 columns return value in another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jmegdan1 jmegdan1 is offline
external usenet poster
  
Posts: 3
Default search value in 2 columns return value in another
2 worksheets

Sheet 1
Area Sector Year
Berkley Retail (BLANK)
Berkley Office (BLANK)
Clawson Retail (BLANK)
Clawson Office (BLANK)


Sheet 2
Area Sector Year
Berkley Retail 1
Clawson Retail 4
Clawson Office 3
Berkley Office 2


How do I get the Year value in sheet 2 to populate into sheet 1 based on 2
matched criteria?
Reply With QuoteReply With Quote