Hi there,
I have quite a complex or conditional statement that ends up being very long when entered in an IF statement format. I was wondering whether this could be tidied up or done in another method! I have simplified the statement below to help you understand it easier!
=IF(Data!C7=4,VLOOKUP(Data!C76,Data!D75:E79,2),VLOOKUP(Data!C7,Data!D6:M19,5))
Basically I have a table of data that normally i would VLOOKUP from (section in bold). The problem i have is that there are 5 exceptions where if a certain value is entered i need it to reference seperate tables (the first of these is in italic. I have a further four statements to add in like this. The only way i can see to do it is keep on creating more and more IF statements, but its getting very confusing!!! Is there a simpler way to do this???
Mnay Thanks in advance
Bookmarks