also about date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI, please help
A B C
1 3-21 4-20 Aries
2 4-21 5-21 Taurus

4 3-30

How to make A5's value be one constellation basic on A4 and the upper form

Thanks
Monker
 
Hi Monker

you can use a VLOOKUP - parameters are (lookup_value, table_to_look_in,
column_with_answer)

e.g.
=VLOOKUP(A4,A1:C2,3)

you will need to make the A1:C2 bit absolute if you are coping it to other
cells (e.g. $A$1:$C$2)

Hope this helps
Cheers
JulieD
 
Back
Top