Okay so I have a list of items and values that go along with them. What I want is for excel to automatically fill in the value in cell B when I enter an item in cell A.
I currently have a very long IF formula which can go on for hundreds of items and I'm looking for a way to shorten this.
The formula I currently have is:
=if(A1=Text(Sheet1!A1;)Sheet1!B1;If(A1=Text(Sheet1!A2;)Sheet1!B2;...
The list contains over 100 items, so if I were to continue like this, the formula would become incredibly long and take a while to complete. Is there any way I can minimise this so it still has the same outcome?
I hope this makes sense. Thanks in advance!
Sylvio
Bookmarks