Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adjusting Formula
I am using the following forumla to find an amount not exactly in line with
my search term. This would pull in the $ amt for the Consumer for CSFS. INDEX('[Apr Past Due.xls]Sheet1'!$C$3:$C$100,MATCH("CSFS",'[Apr Past Due.xls]Sheet1'!$A$3:$A$100,0)+2) Normally the spreadsheet will be laid out to have: CSFS Commercial 100000 Consumer 50000 TMB Commercial 75000 Consumer 25000 When it is laid out like this the above formula works fine. Sometimes the Commercial might be gone which puts the Consumer a line up. Is there a formula that will adjust for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking portions of a formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |