Excel Code Query

bod1467

If your original is generally working as expected, but you simply want the word "Fee" ...

=IFERROR(RIGHT(VLOOKUP(F22,'[Fee Clients.xlsx]Sheet2'!$T:$AB,9,FALSE),3),"Commission")

(Changes in red. Might not work but worth a go. Otherwise follow RMG's suggestion).

Cotta

rmg1 wrote: »

Try this (untested):-
=if(iserror(match(F22,'[Fee Clients.xlsx]Sheet2'!$T:$T,0)),"Commission","Fee")

That works, but how? How does it read what's a "Fee" account from column "AB"?

rmg1

The short answer is .... it doesn't.
It checks to see if the value you're looking for exists in column T and, if it does, gives you the value "Fee". If it can't find it, it gives you "Commission".

rmg1

The short answer is .... it doesn't.
It checks to see if the value you're looking for exists in column T and, if it does, gives you the value "Fee". If it can't find it, it gives you "Commission".

Depending on the values in column AB, I can adjust the formula to take those into account as well.

Cotta

rmg1 wrote: »

The short answer is .... it doesn't.
It checks to see if the value you're looking for exists in column T and, if it does, gives you the value "Fee". If it can't find it, it gives you "Commission".

Depending on the values in column AB, I can adjust the formula to take those into account as well.

Makes sense but I would be interested in how you would incorporate AB for future reference.

andydiysaver

=IF(ISERROR(VLOOKUP(F22,Sheet2!$T:$AB,9,FALSE)),"Fee","Commission")


' if error in the vlookup- any kind of error, don't repeat value, just return fee, otherwise return commission