Find Text (Lower or Upper Case)

M

mralmackay

Hi,
Hopefully a quick query. I've got the following formula to check that
we've received approval within a field in excel. I just need to amend
it to allow for either upper or lowercase use of the phrase "DA".

=IF(ISERROR(FIND("DA",(VLOOKUP(Report!$B16,Data!OpenRecordsezBuy,
14,FALSE)))),"X","Y")

So need it to either find "DA", or to find "da". If either of these
exist show Y, else X.

Any help appreciated. Thanks, Al.
 
D

Dennis

=IF(ISERROR(FIND("DA",UPPER(VLOOKUP(Report!$B16,Data!OpenRecordsezBuy,
14,FALSE)))),"X","Y")
 
R

Ron Rosenfeld

Hi,
Hopefully a quick query. I've got the following formula to check that
we've received approval within a field in excel. I just need to amend
it to allow for either upper or lowercase use of the phrase "DA".

=IF(ISERROR(FIND("DA",(VLOOKUP(Report!$B16,Data!OpenRecordsezBuy,
14,FALSE)))),"X","Y")

So need it to either find "DA", or to find "da". If either of these
exist show Y, else X.

Any help appreciated. Thanks, Al.
Click to expand...

If "dA" and "Da" are also acceptable, use SEARCH in place of FIND.
--ron
 
Top