Afternoon all
i have a formula (below) which as part of a larger spreadsheet looks up the value in a cell to the left (ROW G) and gives me a different value depending on whats found
in essence its an upload spreadsheet we use to move money around different accounts and if the money is for a taxi it comes out of one account / good will gesture another etc etc
i actually have 10 different accounts but can only nest 7 =IF's together so have dropped the 3 that are rarely used
heres an example of some of the accounts just so you can see how my formula is working
TAXI 21506
Good CONDITION bonus 23150
FAMILIARISATION LESSONS 54045
RETURNERS AWARD 23160
if the money to be moved is for "insurance" or "AP REFUND" then the account number will be in the cell above (ROW I)
Please Login or Register to view this content.
the part where i am stumbling is ------ ({"INSUR","AP REFUND"},
i can get a result if it finds "INSUR" but not "AP REFUND"
if i swap them around i get a result for "AP REFUND" but not "INSURE"
many thanks
mike
PS if you are going to suggest a different / better way of doing this i am open to that but i would also like to know where im going wrong on this version for future reference - thanks
Bookmarks