View Single Post
  #1   Report Post  
jay
 
Posts: n/a
Default QUICK HELP - Retrieve value based on two column criteria

I have three columns in worksheet A (id,name,city) in worksheet B I have
(id,name,city) where the ID is not populated. I need to populate worksheet
b(id) with worksheet A(id) where the name and city are equal. Just so you
know, worksheetA has a lot more values than B so I can't just copy/paste.