replace/substitute

  • Thread starter Thread starter gabriel g smit
  • Start date Start date
G

gabriel g smit

Hi All
This thing most probably has a very simple solution - if
one knows how.
i have say column a with 1-60, column b has the names of
localities corresponding to 1-60.
these #s are used in a drop-down list in an access form
and now i sit with the excel output obviously just
indicating the #s (a 2nd sheet gives the corresponding
names/#s)
my q is:
how can i tel column a in the final output to replace
specific #s with specific place names? the excel output
has more than one column where numbers represent text, so
i'll obviously have to select these as i apply the missing
formula.
 
You can use a formula to return the localities.

Use a helper column and put a formula like:

=vlookup(a1,sheet2!$a$1:$b$60,2,false)
(and drag down)

(I guessed that sheet2 was the sheet that held the two column table.)
 
Gabriel

right-click on the Combo Box and choose Format Control.

Fill in the range for the input range with the new column
and define a cell in the same sheet for the row index in
the Cell Link box.

Regards
Peter
 
Back
Top