I have a lookup set up to display a number reference against a name that is selectable via validate 'list'.
It all works fine except when one name in the list is selected, it shows the wrong number reference.
Here's 4 lines from the list (which has 150+):
Queen Elizabeth and Queen Mother 27
Queen Elizabeth Hospital, Kings Lyn 66
Queen Elizabeth Hospital, Gateshead 106
Queen Elizabeth Hospital, Woolwich 31
When you select 'Queen Elizabeth Hospital, Gateshead' from the validate list (cell C3), it strangely displays '27' in the cell C4 instead of 106. All other lookups work fine except this one line.
Any ideas?
Many thanks
It all works fine except when one name in the list is selected, it shows the wrong number reference.
Here's 4 lines from the list (which has 150+):
Queen Elizabeth and Queen Mother 27
Queen Elizabeth Hospital, Kings Lyn 66
Queen Elizabeth Hospital, Gateshead 106
Queen Elizabeth Hospital, Woolwich 31
When you select 'Queen Elizabeth Hospital, Gateshead' from the validate list (cell C3), it strangely displays '27' in the cell C4 instead of 106. All other lookups work fine except this one line.
Any ideas?
Many thanks