Hi,

I have a sheet which connects to sql for data and another sheet which is just records of manual data. A third sheet compares these two sheets using an index and match formula driven from a cell.

The formula works fine if I change the value in the cell for the data of the manual sheet but the sql linked data errors with N/A. Im confident that my formula is correct as it works for the data when referencing the manual data. Strangely enough I got it to work for the SQL data but now its playing up again - any ideas what I am doing wrong please?

```
=INDEX(Data!A:A,MATCH(Coparison!M2,Data!A:A,0))
```

On the above I realise I am asking for the same result as I am comparing to but this is almost a check procedure and as you can see below this works for the manual data

```
=INDEX(ManualData!K:K,MATCH(Coparison!M2,ManualData!K:K,0))
```

## 1 Reply

as you are referencing tables instead of just cells, you will need to modify your formula slightly.

the following is the array format I use:

```
{=INDEX(Data!A:A,MATCH(Coparison!M2,Data!A:A,0))}
```

these brackets are achieve by entering the formula then pressing CtrlÂ + ShiftÂ + Return

hope it helps