Lookup

[srcurrie]

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]

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.