Adjusting Formula

J

Jasmine

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index / Match Help 3
LOOOOONG formula, with drop down selection 1
change formula reference in bulk? 2
Forecasting with formulas HELP 1
Adjusting rows versus columns for formulas 1
Can't Get Formula to work 0
Serious help needed for this project Can anyone help me with this 7
Advanced Criterea in Formulas 2

Top