Can anybody help me with this issue. I am trying to select an item from a pick list and be able to automatically copy the adjacent cell value to another cell.
Example:
This is the pick list
PAPER HOLDER - LEVEL I (CHROME) $2.80
TOWEL BAR - 24" LEVEL I (CHROME) $2.80
TOWEL BAR - 18" LEVEL I (CHROME) $2.80
Once I choose the item to fill in another cell location, I want the adjacent price to automatically fill in another cell location as well.
Example:
This is the pick list
PAPER HOLDER - LEVEL I (CHROME) $2.80
TOWEL BAR - 24" LEVEL I (CHROME) $2.80
TOWEL BAR - 18" LEVEL I (CHROME) $2.80
Once I choose the item to fill in another cell location, I want the adjacent price to automatically fill in another cell location as well.