Exact Lookup

Charlie · Mar 20th, 2002, 05:24 AM

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 · Mar 20th, 2002, 05:33 AM

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 · Mar 20th, 2002, 05:41 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 05:24 AM	#1
Charlie Board Regular Join Date: Mar 2002 Posts: 134	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

Mar 20th, 2002, 05:33 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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

Mar 20th, 2002, 05:41 AM	#3
Charlie Board Regular Join Date: Mar 2002 Posts: 134	Thanks got it, the first formula worked a treat. Charlie