Guys,
I have the below formula which is meant to look for particular numbers and if Excel finds those numbers, then to compare the cell (which has text in it) in the next column with a cell in a range. If it finds a match, then it will get the value in the range, otherwise it will say "Not found".
Unfortunately, due to a EXCEL getting confused between many similar worded cells, I have to use EXACT function, but as EXACT is case sensitive, its causing other problems. Is there a way to use Exact withOUT case sensitivity or perhaps a similar EXCEL function?
Can anyone recommend what I shoud do please.
Formula: =IF(ISERROR(IF(AND(OR($A33=1111,$A33=1112,$A33=1113),EXACT(VLOOKUP($B33,$K$3:$K$46,1,FALSE),$B33)),VLOOKUP($B33,$K$3:$L$46,2,FALSE),IF(AND(OR($A33=2221),EXACT(VLOOKUP($B33,$K$48:$K$71,1,FALSE),$B33)),VLOOKUP($B33,$K$48:$L$71,2,FALSE),"Core"))),"Core",
P.S: because of the multiple IFs, Im only pasting the first half of the iserror argument. (otherwise the formula would be too long...)
P.P.S: Im using Excel 2007.
Thanks & Regards,
Bookmarks