auto populate selected cells

[robert morris]

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

 

[Max]

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

 

[robert morris]

Max,

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

Bob

 

[Max]

Welcome, Bob. Glad it helped.

 

[robert morris]

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

 

[robert morris]

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

Bob

 

[Max]

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$56,MATCH(G10,G$52:G$56,0)))
which returns neat looking blanks: "" for unmatched cases
(Just adapt the desired return to suit)

---