Formula Please

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

Steved

Hello from Steved
Col A 01-Jun to end of month formated as dd-mmm (A1)
Col B Tue Format is =TEXT(A1, "ddd")(B1)
Col C is data 17843 (C1)

The above fills Col A Col B Col C per calendar month
Cell G3 is Tue (the first day of the Month)
Cell G4 is 01 (the first day of the Month)
Cell G5 requires the formula.

ok Column C1 has the data 17843 which needs to goto cell G5
The above is only one day, I will do the rest, I just need
a guide and I will be able to do the complete month.

Thankyou.
 
Hi Steved

is G3 a date formated as "ddd" or did you type the text of tuesday in / same
question for G4

if they are dates formatted then a VLOOKUP should work along the lines of:
=VLOOKUP(G4,$A$1:$C$31,3,FALSE)

if they are typed data then i'm really not sure ... but get back to us and
let us know if the above helped or not

Cheers
JulieD
 
Thankyou Julied
-----Original Message-----
Hi Steved

is G3 a date formated as "ddd" or did you type the text of tuesday in / same
question for G4

if they are dates formatted then a VLOOKUP should work along the lines of:
=VLOOKUP(G4,$A$1:$C$31,3,FALSE)

if they are typed data then i'm really not sure ... but get back to us and
let us know if the above helped or not

Cheers
JulieD






.
Click to expand...
 
Back
Top