can you combine a mid formula with a vlookup

Microsoft Microsoft office excel 2007 ac...
January 10, 2011 at 13:00:04
Specs: Windows XP
I have a list of dates in the following format 8/22/2010 (22 Aug 2010)

What I want to do is combine a mid formula with a vlookup so that I can look up an exchange rate for August from another table. Is this possible ?

Hope you can help

Thanks


See More: can you combine a mid formula with a vlookup

Report •

#1
January 10, 2011 at 13:47:11
Why MID and not MONTH?

With a date in A1 this will look up the month number e.g. 8 in your table_array:

=VLOOKUP(MONTH(A1), table_array, ...)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 10, 2011 at 14:08:37
Cheers Derby,

Works a treat.


Report •
Related Solutions


Ask Question