asked on

Populating cells based on an input in Excel

What I've done is that on cell D8 I enter a part number and it populates other cells using the naming manager and an offset formula....that works great. It gets that data from the Cabinet_data tab.

But what I'm trying to do next is by entering the part number in cell D8 I wanted to pull associated data from the Part Tab. For example on the attachment everything highlighted in red is what I want populated when I enter the part number in D8 for example.
C--Users-lfreund-Desktop-PN-MAIN.xlsm

Ryan Chong

try the array formula that similar to how you do that for Description/ Vendor/ Cabinet.

like:

=IF(ISERROR(INDEX(Table_BEAR_v2.0.accdb3,SMALL(IF(Table_BEAR_v2.0.accdb3=<Compare Value>,ROW(Table_BEAR_v2.0.accdb3)),ROW(1:1)),2)),"",INDEX(Table_BEAR_v2.0.accdb3,SMALL(IF(Table_BEAR_v2.0.accdb3=<Compare Value>,ROW(Table_BEAR_v2.0.accdb3)),ROW(1:1))-1,<Column Number>))

How To Return Multiple Match Values in Excel Using INDEX-MATCH or VLOOKUP
http://eimagine.com/how-to-return-multiple-match-values-in-excel-using-index-match-or-vlookup/

check attached for illustration.
C--Users-lfreund-Desktop-PN-MAIN_b.xlsm

LUIS FREUND

ASKER

Awesome.....I like it. Works perfect!

Quick question. If the part number is blank can the information be blank as well until you enter a part number? I'm afraid the user will get confused.

ASKER CERTIFIED SOLUTION

Ryan Chong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LUIS FREUND

ASKER

PERFECT!!!! Thank you very much Ryan!