General discussion

Locked

Excel Lookup

By brian.d.miller ·
Hi,

I am useing HLookup at present for the following but finding it cumbersome as the label must be at the end of the array (B6:D6) to work. Is there a better way?

A2:A4 are labels
Col B2:E4 gets a '1' input in a cell in a row
I need to get the appropriate label against that row in col A

Nuts Bolts Washers
Nut 1

Bolt 1
Washer 1

There may be 3 or 20 labeled columns involved.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums