Lookup

srcurrie · Mar 22nd, 2002, 06:19 AM

I am working with a price sheet on Worksheet 1, when I pick items on Worksheet 1 I would like to redirect that whole line to Worksheet 2 without ever effecting Worksheet 1. Is this possible? How would it work?

Thanks for everyones input from past questions.

Anne Troy · Mar 22nd, 2002, 06:37 AM

Methinks you would want VLOOKUP instead.

If you've got a sheet of information on sheet 1, and you want a *picklist* on sheet 2, better thatn you use vlookup from sheet2 to find values on sheet1.

There are examples of vlookup all over the place here. Do a search.

Let me know if you have no luck.

Mar 22nd, 2002, 06:37 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Methinks you would want VLOOKUP instead. If you've got a sheet of information on sheet 1, and you want a picklist on sheet 2, better thatn you use vlookup from sheet2 to find values on sheet1. There are examples of vlookup all over the place here. Do a search. Let me know if you have no luck. __________________ ~Anne Troy

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

Mar 22nd, 2002, 06:19 AM	#1
srcurrie New Member Join Date: Mar 2002 Posts: 18	I am working with a price sheet on Worksheet 1, when I pick items on Worksheet 1 I would like to redirect that whole line to Worksheet 2 without ever effecting Worksheet 1. Is this possible? How would it work? Thanks for everyones input from past questions.