Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match Multiple Columns
I want to return a value based on column A & B, all the formulas I know or
have found only allow for a value to be returned when the amount is based in 1 column but as you can see below I have LY, Budget & TY, for each month, I need to specify the column to be returned. This is one of the formula's I've tried. =INDEX(COACCT2008!$C$2:$AL$3000, MATCH(1,(A4=COACCT2008!$A$2:$A$3000)*(B4=COACCT200 8!$B$2:$B$3000),0)) GL_ACCT GL_DEPT NOV_1YR NOV_BUDGET NOV_CURRENT DEC_1YR DEC_BUDGET DEC_CURRENT JAN_1YR 4010 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4010 PA01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4010 PA03 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4010 PA08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4010 PA09 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4010 PA14 -99.36 0.00 0.00 0.00 0.00 0.00 -397.44 4010 PA15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4010 PA23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4010 PA24 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4010 RG02 0.00 0.00 0.00 0.00 0.00 0.00 0.00 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Data in Multiple Columns | Excel Discussion (Misc queries) | |||
Index/Match from multiple columns | Excel Worksheet Functions | |||
I need to match multiple columns before returning a value | Excel Discussion (Misc queries) | |||
Vlookup/match/offset over multiple columns of lable | Excel Discussion (Misc queries) | |||
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions |