Vlookup Issue

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved

Below is the formula I am using to build a monthly Calendar

=IF(MONTH(StartDate+ColNum+0*RowNum)=MONTH
($A$1),StartDate+ColNum+0*RowNum,"")

The below formula is ok for the first row of the calendar,
but under a normal situation you would start the calendar
the following row down but I have started it 11 rows down
and the below formula returns a blank. The date is correct.
G4 is the day A1:C217 is the index and 3 is the column for
which I get the Data which works but the moment the next
date 11 rows down is G15,=VLOOKUP(G15,$A$1:$C$217,3,FALSE)
it comes up blank Is there Another formula that could help
please.

=VLOOKUP(G4,$A$1:$C$217,3,FALSE)This is ok for first row
only

Thankyou.
 
Hi Steved,

I can't quite see where you're coming from with this one.

To begin with, 0*RowNum has no purpose. Is your first formula contained
in A2:A217? If so, every one of those cells will contain the result of
StartDate+1 (unless StartDate happens to be the last day of a month, in
which case they'll all contain ""), and therefore VLOOKUP will never find a
different date.

Try taking out the 0*

Trouble is, I can't help thinking that you would have noticed if your list
of dates looked this way. So, either you haven't given the formula here
that you are actually using, or you're not giving us enough
information/explanation to work with.

Steve D.
 
Hello Stephen

Firstly I import Data into three Columns
Col A = Start of the month to end of month
Col B = Day ie =TEXT(a1 "ddd)
Col C = Data
Each Day has 7 cities of data

What I am hoping to acheive is first build a calendar
in Col K for the Month say June. (May not need to do this).

Here where it gets challenging I want to in Col E to Col I
Mon to Fri as a heading, then a formula to is take the
data from Col C and place it in Col E if it is A Monday,
and the next day under Col F for Tuesday and so on. The
following week I need to do the same again until the
months weeks are completed.

ps I may not need a calendar for this, but I am learning
Formulas and this is only way I know how to approach it.

Thankyou.
 
please refer to my new post
-----Original Message-----
Hello Stephen

Firstly I import Data into three Columns
Col A = Start of the month to end of month
Col B = Day ie =TEXT(a1 "ddd)
Col C = Data
Each Day has 7 cities of data

What I am hoping to acheive is first build a calendar
in Col K for the Month say June. (May not need to do this).

Here where it gets challenging I want to in Col E to Col I
Mon to Fri as a heading, then a formula to is take the
data from Col C and place it in Col E if it is A Monday,
and the next day under Col F for Tuesday and so on. The
following week I need to do the same again until the
months weeks are completed.

ps I may not need a calendar for this, but I am learning
Formulas and this is only way I know how to approach it.

Thankyou.


first
formula contained contain
the result of VLOOKUP
will never find a
.
Click to expand...
 
Back
Top