Home |
Search |
Today's Posts |
#1
|
|||
|
|||
two way match
I have a worksheet with drop boxes in the first two columns of a table. The
user selects two options (manufacturer and product) and the row should fill in the appropriate items from a data table. My search items are in colomn A and B. How can I do this? There are quite a few different products and manufacturers. Thanks, Todd |
#2
|
|||
|
|||
Hi
try the following array formula (committed with CTRL+SHIFT+ENTER): =INDEX(C1:C100,MATCH(1,(A1:A100=lookup_cell_1)*(B1 :B100=lookup_cell_2), 0)) -- Regards Frank Kabel Frankfurt, Germany "Todd" schrieb im Newsbeitrag ... I have a worksheet with drop boxes in the first two columns of a table. The user selects two options (manufacturer and product) and the row should fill in the appropriate items from a data table. My search items are in colomn A and B. How can I do this? There are quite a few different products and manufacturers. Thanks, Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I customize the X-axis in excel to match my dataset? | Charts and Charting in Excel | |||
Match & Index | Excel Worksheet Functions | |||
How do i Match all COLUMNS? | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |