Ok, that's MUCH simpler than the one I had. Thank you so much!

"Arvi Laanemets" wrote:

Hi

=VLOOKUP("Contract 1206",Contracts!$A$1:$B$243,2,0)

Arvi Laanemets


"Edye" wrote in message
...
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.