Hello, I am trying to paste data via vlookup into a large sheet which contains 2000 rows.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
Pieces of data come in from various sources and often they only apply to certain rows within the spreadsheet.
<o
></o
>
The only constant piece of reference information I have is the ‘lookup value.’ <o
></o
>
( Which is the property reference ‘Establishment Number’ which I try to place in column A in all tabs)
<o
></o
>
<o
></o
>
I want to be able to return the information from column B on ‘additional info!’ into column H in ‘Property info!’ (These cols are both ‘Location’ (Name)<o
></o
>
(i.e, paste in the ‘Location’ Name from ‘Additional Info!’ into ‘Property Info!’. <o
></o
>
I also need to be able to do this with any other information which I receive)
<o
></o
>
<o
></o
>
However, the row numbers on both tabs do not match because there are often multiple occurrences of the 'Establishment Number' reference on one tab, and there may only be a single occurrence of this reference on the other tab. This means that I cannot specify absolute references for either the copy or paste locations.
<o
></o
>
<o
></o
>
I am wondering if there is any way of instructing excel to look up and return the information that I need using the ‘Establishment Number’ references in column A on each tab, and returning the corresponding information from the relative column, such as all ‘Location’ Names in col B which match the ‘Establishment Number’ in Col A, rather than the specific column and cell??
<o
></o
>
<o
></o
>
Please help.<o
></o
>
<o
></o
>
S.<o
></o
>




Pieces of data come in from various sources and often they only apply to certain rows within the spreadsheet.
<o


The only constant piece of reference information I have is the ‘lookup value.’ <o


( Which is the property reference ‘Establishment Number’ which I try to place in column A in all tabs)
<o


<o


I want to be able to return the information from column B on ‘additional info!’ into column H in ‘Property info!’ (These cols are both ‘Location’ (Name)<o


(i.e, paste in the ‘Location’ Name from ‘Additional Info!’ into ‘Property Info!’. <o


I also need to be able to do this with any other information which I receive)
<o


<o


However, the row numbers on both tabs do not match because there are often multiple occurrences of the 'Establishment Number' reference on one tab, and there may only be a single occurrence of this reference on the other tab. This means that I cannot specify absolute references for either the copy or paste locations.
<o


<o


I am wondering if there is any way of instructing excel to look up and return the information that I need using the ‘Establishment Number’ references in column A on each tab, and returning the corresponding information from the relative column, such as all ‘Location’ Names in col B which match the ‘Establishment Number’ in Col A, rather than the specific column and cell??
<o


<o


Please help.<o


<o


S.<o

