searching in an array

How do I locate a value in an array (Ex. Check to see if B2 from sheet1
equals a value in column C of sheet 2) then return the corresponding value in
a different array if they equal ( B2 on sheet 1 equals C23 in column C, so
the returned value is the value of the corresponding value in column D, for
this example D23)?

enter in sheet1 cell C2
=VLOOKUP(B2,Sheet2!C1:D30,2,FALSE)

In this example the columns are only 30 cells deep
the 2 stands for the second column in the range C1:D30
--
Greetings from New Zealand
Bill K

"sisko101" <sisko101@discussions.microsoft.com> wrote in message
news:F04FD162-9C32-4729-AEBE-40F4EDA08CF2@microsoft.com...
> How do I locate a value in an array (Ex. Check to see if B2 from sheet1
> equals a value in column C of sheet 2) then return the corresponding value
> in
> a different array if they equal ( B2 on sheet 1 equals C23 in column C, so
> the returned value is the value of the corresponding value in column D,
> for
> this example D23)?