Help!!! I am sure there's something simple going on here, but I've looked at it too long and my brain is fried. I have two reports that I pull into a spreadsheet each month. One shows the salesperson associated with a sales order, the other does not. I need the backorder list (2nd sheet) to show the salesperson as well, so I am trying to make the backorder salesperson field look up the salesperson for that particular sales order number (column A) on the Order sheet. I tried several ways and always got a #REF error when it found a match. Can someone please figure out this one?

Thanks!
Cara