auto populate selected cells
 

I have a group of names (text) in Col G52:G56. Above that in Col G10:G50
these four names appear several times each. In Col H52:H56 I need to enter a
quantity number and have it populate any cell in H10:H50 with the name
adjacent to the qty from G52:G56, i.e., if G52 has the name of Widget and I
enter a new qty in H52, Excel needs to enter that qty in any cell from
H10:H50 and the name of Widget next to it.

There are nine (9) of these across the worksheet in Columns J & K, M & N, P
& Q, S & T, W & X, Z & AA, AC & AD, AF & AG.

I don't know where to start.

Have I confused anyone except myself?

BoB

auto populate selected cells
 

In H10, copied down to H50:
=INDEX(H$52:H$56,MATCH(G10,G$52:G$56,0))

Frame it up likewise for the other pairs
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"robert morris" wrote:

I have a group of names (text) in Col G52:G56. Above that in Col G10:G50
these four names appear several times each. In Col H52:H56 I need to enter a
quantity number and have it populate any cell in H10:H50 with the name
adjacent to the qty from G52:G56, i.e., if G52 has the name of Widget and I
enter a new qty in H52, Excel needs to enter that qty in any cell from
H10:H50 and the name of Widget next to it.

There are nine (9) of these across the worksheet in Columns J & K, M & N, P
& Q, S & T, W & X, Z & AA, AC & AD, AF & AG.

I don't know where to start.

Have I confused anyone except myself?

BoB

auto populate selected cells
 

Max,

Thanks a zillion! Works perfectly. You people amaze me.

Bob

"Max" wrote:

In H10, copied down to H50:
=INDEX(H$52:H$56,MATCH(G10,G$52:G$56,0))

Frame it up likewise for the other pairs
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"robert morris" wrote:

I have a group of names (text) in Col G52:G56. Above that in Col G10:G50
these four names appear several times each. In Col H52:H56 I need to enter a
quantity number and have it populate any cell in H10:H50 with the name
adjacent to the qty from G52:G56, i.e., if G52 has the name of Widget and I
enter a new qty in H52, Excel needs to enter that qty in any cell from
H10:H50 and the name of Widget next to it.

There are nine (9) of these across the worksheet in Columns J & K, M & N, P
& Q, S & T, W & X, Z & AA, AC & AD, AF & AG.

I don't know where to start.

Have I confused anyone except myself?

BoB

auto populate selected cells
 

Welcome, Bob. Glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"robert morris" wrote in message
...
Max,

Thanks a zillion! Works perfectly. You people amaze me.

Bob

auto populate selected cells
 

Hey Max,

No problems, and this is not a big deal but, if occasionally a Column like
H52 shows < OUT Excel returns #N/A instead of < OUT Is there a way to
have it show OUT ? We are totaling these comumns.

Many thanks

Bob

"Max" wrote:

Welcome, Bob. Glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"robert morris" wrote in message
...
Max,

Thanks a zillion! Works perfectly. You people amaze me.

Bob

auto populate selected cells
 

Never mind my last post Max. It was my error. Thanks again.

Bob

"Max" wrote:

Welcome, Bob. Glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"robert morris" wrote in message
...
Max,

Thanks a zillion! Works perfectly. You people amaze me.

Bob

auto populate selected cells
 

To trap any #N/A errors, you could use an IF(ISNA(..) error trap
to wrap around the MATCH part of it

Eg in H10, copied down to H50:
=IF(ISNA(MATCH(G10,G$52:G$56,0)),"",INDEX(H$52:H$5 6,MATCH(G10,G$52:G$56,0)))
which returns neat looking blanks: "" for unmatched cases
(Just adapt the desired return to suit)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---