Hi Im a bit of an excel newbie and im trying to do something that i cannot find a solution for that is probably quite simple for you guys on here.
I have a table it only has 2 columns, the first colum contains locations(20 in total) and each location has a numerical value in column 2.
In my excel sheet I am using vlookup to access the table containing numbers for each location. eg, Liverpool returns 1100now depending on the result of some calculations I may need to alter the number for this location; This is my problem how do I change or Rewrite the data in the table cell that corresponds to this location???
Thanks in Advance for any responses.
Bookmarks