K
K-Man
Hi,
I have a spreadsheet in which I am querying some data (by VLOOKUP)
from another spreadsheet. My problem is that there might be multiple
entries of the serial number in Column A, however I want to update 2nd
spreadsheet with multiple entries of same serial number, it will only
take the first one on the list and will not update the second or third
entry of same serial no.
For e.g.
A B
1 11
2 12
3 13
1 14
2 15
I want to update both entries of cells A1 and A4 and A5 as new records
on the second spreadsheet.
I hope I explained my issue enough for anyone to help out.
thanks in advance.
I have a spreadsheet in which I am querying some data (by VLOOKUP)
from another spreadsheet. My problem is that there might be multiple
entries of the serial number in Column A, however I want to update 2nd
spreadsheet with multiple entries of same serial number, it will only
take the first one on the list and will not update the second or third
entry of same serial no.
For e.g.
A B
1 11
2 12
3 13
1 14
2 15
I want to update both entries of cells A1 and A4 and A5 as new records
on the second spreadsheet.
I hope I explained my issue enough for anyone to help out.
thanks in advance.