View Single Post
  #1   Report Post  
Edye
 
Posts: n/a
Default Match text to another worksheet and return a certain value

I have 2 worksheets. The first is essentially a 2-column sheet that has
names in column A and numbers in column B. For example, column A would be
"George" and column B would be $20.00 (his hourly rate). On worksheet 2, I
have a column that has some of the names from the worksheet 1 column A. I
would like to have a column on worksheet2 that spits out the worksheet 1
column B value ($20) whenever the worksheet1 column A value (George) is found
on worksheet 2.