Thread: Vlookup Error

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

baffour,

Welcome to the forum. This thread has being closed as duplicate posts are not permitted. Also your other post was move to his own thread and tacking your question on to someone else's is not permitted

Please take 5 mins to read our forum rules below

VBA Noob