Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Change column Number vrs Text
Hello!
I use next formulae and work fine =INDEX($A$1:$B$1000;MATCH(C1;$B$1:$B$1000;0);1) where A B Number Text Now, I would a formulae where columns change. A B Text Number Thanks in advance. an |
#2
|
|||
|
|||
=INDEX($B$1:$B$1000;MATCH(C1;$A$1:$A$1000;0);1)
at a guess -- HTH RP (remove nothere from the email address if mailing direct) "an" wrote in message ... Hello! I use next formulae and work fine =INDEX($A$1:$B$1000;MATCH(C1;$B$1:$B$1000;0);1) where A B Number Text Now, I would a formulae where columns change. A B Text Number Thanks in advance. an |
#3
|
|||
|
|||
Ok, Bob Phillips.
Many thanks. Work fine. an -----Original Message----- =INDEX($B$1:$B$1000;MATCH(C1;$A$1:$A$1000;0);1) at a guess -- HTH RP (remove nothere from the email address if mailing direct) "an" wrote in message ... Hello! I use next formulae and work fine =INDEX($A$1:$B$1000;MATCH(C1;$B$1:$B$1000;0);1) where A B Number Text Now, I would a formulae where columns change. A B Text Number Thanks in advance. an . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
how do i change the column width over a number of rows in the sam. | Excel Worksheet Functions | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions |