Tech Support Forum banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
161 Posts
Discussion Starter · #1 ·
Hi guys,

I needed some help the other week to solve an issue.

I was advised to use the VLOOKUP formula which solved my problem.

Now I have another.

Here is my script

=VLOOKUP(E14,'Software Script'!$A$2:$H$84,8,FALSE)

E14 is the cell is the LOOKUP value which is a Data Validation List.
A2:H84 is the array that contains workers details like First name, last, mobile, licence etc.

Now I tried to before and it worked.... I click on on E14 and change the contents of that cell. Before when E14 is changed all cells containing the script were 'updated'.

Now it is not changing. It seems to change if I edit something in the formula and enter the changes it will then change the contents of the cell to reflect whats in E14.

Is there some kind of option that I have unknowingly played with or am I doing something wrong and cannot notice it.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top