What Function to use????

  • Thread starter Thread starter yh73090
  • Start date Start date
Y

yh73090

In column C3 I want to enter number 0-23 and depending on the numbe
populate the corresponding column to the right.

How do i do this???
Is it even possible???

Newbi
 
what do you want to populate the corresponding column to the right with?

if you have another table somewhere with the numbers 0 to 23 down the left
column and a related bit of info in the next column then you can use the
VLOOKUP function to achieve what you want.

assuming that your numbers 0 - 23 and the related bit of info are on Sheet2
cell references A2:B24

then you can type in C3
=VLOOKUP(C3,Sheet2!$A$2:$B$24,2,false)
this means, lookup the value in C3 in the table on sheet 2, and return the
value from the 2nd column of the table, where there is an exact match.

Hope this helps
Cheers
JulieD
 
still unclear on your requirements

you want to you a number between 0 & 23 in cell C3 and in D3 you want to see
an "x" ... do you want to see the same amount of x as the number in C3

e.g..

A B C D
3 5 xxxxx

or something else?

Cheers
JulieD
 
Enter this formula in cell D3:

=IF($C3>=COLUMN()-3,"X","")

and copy across to Z3
 
newbie, if you want to pouplate in the same column (can be elegantas well) you can use thsi formula

=REPT("X";$c$3

- newbie wrote
In column C3 I want to enter number 0-23 and depending on the numbe
populate the corresponding column to the right
 
Back
Top