Hello, Seeking some assistance please.
I have a formula which creates either a name or a blank “” in cell AB18.I wish to combine the result of that cell with the larger formula.
If AB18 is blank then carry out the second if below.
If AB18 has a combination of number and text (2. redcoat ). Then do not carry out the the second if
=IF($AC16-$AD16<3,"",INDEX(pbet!$C$1:$C$1463,$AD16+COLUMNS($AB13:AB13)))
Please attach a sample of your workbook so we can work on solutions using your own data. Remember to remove/replace any sensitive info before uploading the file.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks