software

i'm using validation. in each cell next to my named range cell is the price.
when i go back to my sheet with the drop down menu that allows me to pick
whatever from the named cel range on the other sheet how can i get the price
in the cell next to it to show up in the cell next to the one i'm selecting?
does this make sense to anyone ? thanks in advance for any suggestions.use the VLOOKUP function to lookup the price according to the name.

quot;Christopher Gilbertquot; wrote:

gt; i'm using validation. in each cell next to my named range cell is the price.
gt; when i go back to my sheet with the drop down menu that allows me to pick
gt; whatever from the named cel range on the other sheet how can i get the price
gt; in the cell next to it to show up in the cell next to the one i'm selecting?
gt; does this make sense to anyone ? thanks in advance for any suggestions.
gt;