Nesting formula

[DSNTNOENUF]

I have two formulas I would like to combine.

The first is standard =vlookup(a1,b1:q23,1,0)

the second is looking for a..


'has more perhaps but at least contains this text'
=IF(ISERR(FIND("TOTAL OF PAYMENTS",N:N)),"FALSE",INPUT!N230)

The combined result I believe should look something like this:

=vlookup(IF(ISERR(FIND("TOTAL OF PAYMENTS",N:N)),"FALSE",INPUT!N230),b1:q23),1,0) but I cant seem to make it work.

Essentially I want to increase the functionality of the second formula to search vertically for a cell that contains at least part of the values I need and return the entire value of that cell. From there I can parse the data reliably.

Any help is appreciated.

 

[yky]

Does "FIND("TOTAL OF PAYMENTS",N:N)" work for you? It doesn't for me. What works for me is "MATCH("*TOTAL OF PAYMENTS*",N:N,0)