I have 2 worksheets. On sheet 1 is a list of items on order sorted by
customer number. The other sheet is a list of customer numbers in column A
and coresponding names in column B. I want to display the customer name
instead of the customer number in sheet 1 from the coresponding name in
column B that matches the number in column A in sheet 2. What formula can I
use for this?