I am trying to bring jsut the value of the vlookup from a cell. I have it looking up a price and then when i go onto my main sheet and run my macro it won't bring the value over because there is a formula. I want it to bring just the value over. I hope this explains it. Thanks
Bookmarks