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. 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"))))))))
Where am I going wrong with the formula? Hope someone can help
Andy
Bookmarks