I have a file where I have to input new values each month. The name of the customer may sometimes change so I can't use a VLookup to extract the information.
What I was thinking of doing was inserting a new column to create the new names as the VLookup Source.
For example, in July Customer's name was Aethis for 32,956. On the source document from where I have to extract the information the this same amount falls under the name eXpanded Media.
I had to manually type in the 32,956 under Aethis. I thought of using something like this:
I used the array for column E because that's where all the values were located. I used the offet because eXpanded Media was in Column A. I don't know how to use the offset function so it may be wrong.
I couldn't use a Vlookup to bring in the eXpanded Media because the spreadsheets are not set-up for the VLookup to work.
thanks for your help.