Good Morning
I can't use the filter for the following resons:
sheet2 contains User2 (contains the list of 194 users), Type, Date, Time
columns
I inserted User1 column (contains the list of 80 users) and these are the
users that i want
The result column is where I applied the Vlookup formula
If I filter the result column and delete all the N/A the problem is that my
results are not displayed next to their row.
look at the exapmle below
user @Y118 is on row 5 and the result column is displayed on row 3. If I
filter NA from the result column i will be deleting row 5 which has the data
for user @Y118
1 uSER1 uSER2 TYPE RESULT DATE
TIME
2 @Y040 @Y530 BSYS #N/A 2/8/2006 8:48:00
3 @Y118 @Y042 BSYS @Y118 2/14/2006 13:51:00
4 @Y131 @Y072 BSYS #N/A 1/20/2006 10:21:00
5 @Y133 @Y118 BSYS #N/A 1/17/2006 7:13:00
what i really need is a function like the Vlookup function that will be done
on a new sheet and that will match the User1 and User2 and copy the entire
row of matched row of User2
Please Advice thank you I really appreciate the effort
"Bryan Hessey" wrote:
>
> Hi,
>
> On Sheet2 after you have an *N/A list, select a cell in row 1, then
> Data, Filter, Autofilter, and use the dropdown arrow to select all *N/A
> items.
>
> Select all displayed rows (complete rows all together), COPY, and paste
> into Sheet 1 after your present data.
>
> HTH
>
> --
>
> Student Wrote:
> > Thank you for the fast respond that solved the matching problem
> > However, sheet2 is a table and upon finding the exact match for the
> > column I
> > need to copy the entire row to sheet1
> > what function may i use for this
> > thank you again
> >
> > "Bryan Hessey" wrote:
> >
> > >
> > > Try vlookup(A1:sheet2!A1:A100,1,False)
> > >
> > > or better
> > >
> > > =vlookup(A1:sheet2!A:A,1,False)
> > >
> > > and the items flagged #N/A are your missing list
> > >
> > > --
> > > Student Wrote:
> > > > Hello All,
> > > > I am merging two work sheets
> > > >
> > > > the first sheet contains 80 rows and the second sheet contains 194
> > rows
> > > > and
> > > > some of these rows are duplicated in sheet 2.
> > > >
> > > > I am using Lookup to determine if the 80 rows from sheet 1 exist
> > in
> > > > sheet 2.
> > > > So far the lookup function works fine.
> > > > However, if a row in sheet 1 is missing in sheet 2 i get the next
> > > > larger
> > > > value and i don't want that.
> > > > when I further resarched it I found the following note about
> > lookup
> > > > function.
> > > >
> > > > "If LOOKUP can't find the lookup_value, it matches the largest
> > value
> > > > in
> > > > lookup_vector that is less than or equal to lookup_value. "
> > > >
> > > > 1)I need help with the following:
> > > > is there any other function that i can use to return 0 if the value
> > in
> > > > sheet
> > > > 1 is not found in sheet2
> > > > 2)How can I accomidate the duplicate values in sheet2 ...I do want
> > > > these
> > > > values to be duplicated in my results too
> > > >
> > > > thank you in advance
> > >
> > >
> > > --
> > > Bryan Hessey
> > >
> > ------------------------------------------------------------------------
> > > Bryan Hessey's Profile:
> > http://www.excelforum.com/member.php...o&userid=21059
> > > View this thread:
> > http://www.excelforum.com/showthread...hreadid=534525
> > >
> > >
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=534525
>
>
Bookmarks