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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CHANGE LOWER CASE TO UPPER CASE? 1
Upper or Lower case 11
Upper & Lower case problem in VBA 2
vlookup -- Upper case and Lower case text 1
filtering to separate upper & lower case 5
converting lower case text to upper case? 2
Distinguishing between upper & lower case characters for vlookup ..... 3
Upper case to Lower case 5

Top