Thread: Find function
View Single Post
  #1   Report Post  
Jenniferpod Jenniferpod is offline
Junior Member
 
Posts: 8
Default Find function

I have two worksheets. In cell a2 of worksheet 1 I want to find if the value of worksheet 1 cell b2 exists within worksheet 2 column b. If found, I want to return the value of worksheet 2 column a (same row that the the original lookup was found). If not found, I want to leave the cell blank.