I have tried and tried to figure this out by looking at past discussions, but
I keep missing something. I have a table like this that is linked to a table
on the internet, so I can't change the format of the table. The Month column
is a custom formatted cell showing the year and month for the settling price.
I need to make a cell in another sheet that finds the correct month/year and
gives me the settle price. Because the table is liked to one on the
internet, the month column is changing at least once a month so I need a
lookup function to keep finding the values.
Month Settle
9-Aug 15.04
9-Sept 15.67
10-Jan 16.71
10-Feb 16.82
11-Jan 16.23
11-Feb 17.85
=LOOKUP("9-Aug",Sheet1!A8:A31,Sheet1!G8:G31)
This function gives me a #N/A message. I think it is because excel sees
9-Aug as 8/9/2009. This is fine, but when I try
=LOOKUP(8/9/2009,Sheet1!A8:A31,Sheet1!G8:G31) I still get #N/A.
It seems like it should be really easy to do, I just can't seem to get the
function correct. I have also tried the VLookup function, but I have the
same problems. Thanks for your help and my Excel skills are fairly basic so
I apologize if this seems very elementary.