Exact Lookup

[Charlie]

Hi, I have a workbook consisting of 3 worksheets, i have to perform an exact lookup to find the codes for people on a worksheet called people.I am working on a worksheet called data,how do i achieve this, i have tried various methods each resulting in #REF
thanks
Charlie

 

[Dave Hawley]

Hi

=VLOOKUP("Bill",Sheet1!A1:B20,2,FALSE)

Or

=INDEX(Sheet1!A1:B20,MATCH("Bill",Sheet1!A1:A20,0),2)

Would both look in Column A of sheet1 for "Bill" and return the value from the corresponding row in Column B

 

[Charlie]

Thanks got it, the first formula worked a treat.
Charlie