| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Uneven column lookup
You are welcome
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "brownti via OfficeKB.com" <u31540@uwe wrote in message news:9edca45573480@uwe... Both work perfect! Thank you very much Ashish Mathur wrote: Hi, Try this =INDEX(Sheet1!$F$3:$F$6,SUMPRODUCT((Sheet1!$C$3: $E$6=Sheet2!B4)*(ROW(Sheet1!$C$3:$C$6)-ROW(Sheet1!C$2))),1) and copy down Sheet1!$C$3:$E$6 is the 4 column shown in your question below Sheet2!B4 contains 100 on another worksheet I have a table that looks like the following: [quoted text clipped - 28 lines] Thanks for any input! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200911/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Uneven Columns | Excel Worksheet Functions | |||
| Compare 2 uneven colums | Excel Discussion (Misc queries) | |||
| Font looks uneven in spreadsheet | Excel Discussion (Misc queries) | |||
| lookup with uneven columns | Excel Worksheet Functions | |||
| An uneven time-increment | Charts and Charting in Excel | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
