Text longer than 255 characters in Excel cells
I'm looking online and can't seem to come across what I'm looking for (it's possible it's a bit ridiculous, too) so I need the amazing brains of Icrontic. I'm working on something for work and I'm hoping to get desired results utilizing the IF function. To keep the explanation as simple as I can (I think), let's just say I'm using 4 cells total, 2 of which have more than 255 characters in them, 1 that is a dropdown (with >255chars that contains the same info as one of the populated other cells) and one blank cell.
Let's see if I can explain what I need without hurting your brains with my thought process: If CellA dropdown information matches the same info in CellB, then CellC needs to be populated with information from CellD. Does that make sense? In simpler (maybe?) terms the function would be =IF(B2=D100, A5=A100), but since the 255 character limit gives me this error "Text values in formulas are limited to 255 characters. To create text values longer than 255 characters in a formula, use the CONCATENATE function or the concatenation operator (&)" I'm not sure what I can do.
I'm not really familiar with using the concatenate function and I'm not even sure if I can break one cell into 3 or more and then use the concatenate function within an IF function to get my results. Without needing to code a workaround (because work allows none of that stuff...think all you have is a laptop with office and no other abilities to accomplish this) Is there an simpler way use the IF function with cells greater than 255 characters and do you have any recommendations for my problem above?
Thanks in advance for anything and sorry if I just gave you the "WTF is he talking about" face.
Also, I don't have my fire resist gear on today so be gentle.