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.

"Christopher Gilbert" wrote:

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.