U
UKuser
Hi Guys,
Lets say I have a range of data as such:
3 - 4 (=AB)
5 - 6 (=CD)
7 - 8 (=CD1)
And my value is 5.24 - I want the formula to return CD. With a VLOOKUP
you could do this I know, but as the value is between the two columns,
is there a way to do this?
On another point, lets say I have a list:
1) Name 1
2) Name 2
3) Name 3
4) Name 4
And I need to repeat that elsewhere, but only want the number of rows
depending on the number in the above list, is there a way to replicate
them without having to use loads of IF commands - i.e.
IF (row1="name1","name1"," ")
and so on. The reason being, is if the cell was blank, it would leave
lots of blank lines, and may not look quite right - i.e
(blank)
Name 2
(blank)
Name 4
If that doesnt make sense I will try and elaborate a bit more, but
thanks in advance.
Antony
Lets say I have a range of data as such:
3 - 4 (=AB)
5 - 6 (=CD)
7 - 8 (=CD1)
And my value is 5.24 - I want the formula to return CD. With a VLOOKUP
you could do this I know, but as the value is between the two columns,
is there a way to do this?
On another point, lets say I have a list:
1) Name 1
2) Name 2
3) Name 3
4) Name 4
And I need to repeat that elsewhere, but only want the number of rows
depending on the number in the above list, is there a way to replicate
them without having to use loads of IF commands - i.e.
IF (row1="name1","name1"," ")
and so on. The reason being, is if the cell was blank, it would leave
lots of blank lines, and may not look quite right - i.e
(blank)
Name 2
(blank)
Name 4
If that doesnt make sense I will try and elaborate a bit more, but
thanks in advance.
Antony