View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SJW SJW is offline
external usenet poster
 
Posts: 5
Default More help w/ Match or Lookup

I am trying to build a worksheet which will search on data from sheet 1 from
a column in sheet 2, and place the text result of an unknown intersection of
sheet 2 back into sheet 1
sheet 1:
Line 125 (g3)
Name "result"
sheet 2:
column J (contains line #)
columb D (contains name)

I'm trying to look for the line #, find the name in that row, and place the
name into the cell on sheet 1.