Hello,
I am new to the power of Excel and would like to create a document using the logic below.
I would like to setup a sales document where if a cell equals a specific text (already found in a lookup table) then the cell below it will be populated with additional information.
So far I have tried to use the IF function but I get the error #VALUE!. I assume I am getting this error because I have selected multiple values. When I try my equation with only one IF statement instead of multiple it works fine.
I know how to get the equation to work, but I (personally) think it looks bad and it seems like there would be another way to create the equation.
Below is an example of what my excel spread sheet looks like (I have also attached the excel spread sheet if you would like to play with it.
My spreadsheet.png
What I thought I could do is make it so that if A2 equaled any of the lookup values that ended with ABC would prompt 'extra text' in cell A3.
Wanted Equation.png
However I get a #VALUE! instead.
Now I know I can make a very long equation with LOTS of IFs....
e.g. IF(A2=A12,C6,IF(A2=A13,C6,IF(A2=A14,C6,....
but I hope there is an better equation to use.
Can anyone help me with this equation. This is the last part of my spreadsheet that I need to complete to have a final product to release to the rest of my team.
Bookmarks