K
KarenF
Hi,
I have a rather large spreadsheet which I am using to populate another based
on vlookups. On this occasion, I wish to look up an ID and a date from the
large spreadsheet (the ID is in column A and may repeat, the date is in
column C, and again may repeat, but together with the ID, there should only
be 1 occurrance of the combination) and return a value from another column
(Employment Status). Both the large spreadsheet and the spreadsheet I wish
to populate are ongoing documents and will increase in length.
Any ideas would be gratefully received.
Many thanks,
Karen
I have a rather large spreadsheet which I am using to populate another based
on vlookups. On this occasion, I wish to look up an ID and a date from the
large spreadsheet (the ID is in column A and may repeat, the date is in
column C, and again may repeat, but together with the ID, there should only
be 1 occurrance of the combination) and return a value from another column
(Employment Status). Both the large spreadsheet and the spreadsheet I wish
to populate are ongoing documents and will increase in length.
Any ideas would be gratefully received.
Many thanks,
Karen