Hi All
I have created a Vlookup formula but i am getting some errors in the string.
How can i get the formula to display all the values and data in the string? The error occurs when I select London Regional,Newport, or Peterborough in the relevant cell. Once I select any of the options mentioned, the cell returns a value of ZERO, rather that the figure in the string. See formula below:
=IF(A35="Belfast","2064203",IF(A35="Durham","2074203",IF(A35="Glasgow","2054203",IF(A35="GRO","Nil",IF(A35="ION","5004209",IF(A35="Liverpool","2024203",IF(A35="London HQ","5004203",IF(A35="London Regional","5004211",)*IF(A35="Newport","2044203",)*IF(A35="Peterborough","2034203"))))))))
What am I doing wrong? Hope someone can help ?
Andy
Bookmarks