Bill Williamson
Board Regular
- Joined
- Oct 7, 2019
- Messages
- 124
Hello and good morning,
I am currently importing, sometimes multiple rows of data. If I only import 1 line my index/Match formula will move down 1 line.
If I import more than 1 row it still only moves down 1 row. Here is the Formula I am using. I believe its responsible for a circular reference I keep getting as well.
' =INDEX(I:I,MATCH(G1040,G:G,0))
Here is a screen shot of my Data sheet.
Column H is basically the size of the welded assembly. It is supposed to look at the part number in Column G and see if it has been entered before,
If so It will Fill in Column H with the matching size of part.
I would appreciate any advice on this problem.
Thank you,
Bill Williamson
I am currently importing, sometimes multiple rows of data. If I only import 1 line my index/Match formula will move down 1 line.
If I import more than 1 row it still only moves down 1 row. Here is the Formula I am using. I believe its responsible for a circular reference I keep getting as well.
' =INDEX(I:I,MATCH(G1040,G:G,0))
Here is a screen shot of my Data sheet.
Column H is basically the size of the welded assembly. It is supposed to look at the part number in Column G and see if it has been entered before,
If so It will Fill in Column H with the matching size of part.
I would appreciate any advice on this problem.
Thank you,
Bill Williamson