Sunny
You were gracious enough to help me with a different file, but it is the same concept. For some reason I could not make the adjustment. Can you adjust my vlookup formula so that when the date is entered the data placed in the appropriate cell?
Thank you
Hi Melinda
This requirement is much more difficult to do as your data is not arranged in the correct tabular format. There are merged cells in your header and this is a real problem. I am using INDEX and MATCH to get the info required.
In future you will need to ensure that your data is in a tabular format with no merged cells. Otherwise it will be very difficult to extract the data.
Sunny
is this one what you want?
Sunny and Clark
Thank you so very much! I really appreciate the advise about the data format. Clark, I like your idea, something that I had not thought about.
Appreciate all of the help..