Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP question
I have 2 sheets, The first sheet has coulmns 1 with a name and column 2
with a value. The second sheet has column 1 with a name and other columns. Using the name in sheet2, I want to find an exact match with a name in column1 of sheet1 and then move the corresponding value in column 2 of shhet 1 to sheet2. I think this can de done with VLOOKUP but I can't get past the second parameter. Can someone help me with this? TIA. PF. |
#2
|
|||
|
|||
=VLOOKUP(A1,Sheet2!A1:B100,2,FALSE)
-- HTH RP (remove nothere from the email address if mailing direct) "Pierre Fichaud" wrote in message ... I have 2 sheets, The first sheet has coulmns 1 with a name and column 2 with a value. The second sheet has column 1 with a name and other columns. Using the name in sheet2, I want to find an exact match with a name in column1 of sheet1 and then move the corresponding value in column 2 of shhet 1 to sheet2. I think this can de done with VLOOKUP but I can't get past the second parameter. Can someone help me with this? TIA. PF. |
#3
|
|||
|
|||
The second parmeter your referring to is the Table_array which is the area
you want the formula to "Look" for the value. This will always include the first column (lookup value) and the column(s) where the value to be looked-up resides. In the example you've given, the Table_array should be 'Sheet1'!A1:BXX. With XX indicating the number of rows to include in the array. The third parmeter is the column where the lookup value is located. In your example would be "2". Since your looking for an exact match to your lookup, parmeter 4 should be "False" "Pierre Fichaud" wrote: I have 2 sheets, The first sheet has coulmns 1 with a name and column 2 with a value. The second sheet has column 1 with a name and other columns. Using the name in sheet2, I want to find an exact match with a name in column1 of sheet1 and then move the corresponding value in column 2 of shhet 1 to sheet2. I think this can de done with VLOOKUP but I can't get past the second parameter. Can someone help me with this? TIA. PF. |
#4
|
|||
|
|||
=vlookup(a1,sheet1!a1:b863,4,false)
I get #REF. I want the value in the 4th column in sheet1 to be inserted in the cell when any of A1 to b863 match a1. PF. Bob Phillips wrote: =VLOOKUP(A1,Sheet2!A1:B100,2,FALSE) -- HTH RP (remove nothere from the email address if mailing direct) "Pierre Fichaud" wrote in message ... I have 2 sheets, The first sheet has coulmns 1 with a name and column 2 with a value. The second sheet has column 1 with a name and other columns. Using the name in sheet2, I want to find an exact match with a name in column1 of sheet1 and then move the corresponding value in column 2 of shhet 1 to sheet2. I think this can de done with VLOOKUP but I can't get past the second parameter. Can someone help me with this? TIA. PF. |
#5
|
|||
|
|||
=vlookup(a1,sheet1!a:d,4,false) is the correct answer. Thanks for putting me on
the right track. PF. Jose366 wrote: The second parmeter your referring to is the Table_array which is the area you want the formula to "Look" for the value. This will always include the first column (lookup value) and the column(s) where the value to be looked-up resides. In the example you've given, the Table_array should be 'Sheet1'!A1:BXX. With XX indicating the number of rows to include in the array. The third parmeter is the column where the lookup value is located. In your example would be "2". Since your looking for an exact match to your lookup, parmeter 4 should be "False" "Pierre Fichaud" wrote: I have 2 sheets, The first sheet has coulmns 1 with a name and column 2 with a value. The second sheet has column 1 with a name and other columns. Using the name in sheet2, I want to find an exact match with a name in column1 of sheet1 and then move the corresponding value in column 2 of shhet 1 to sheet2. I think this can de done with VLOOKUP but I can't get past the second parameter. Can someone help me with this? TIA. PF. |
#6
|
|||
|
|||
If you want index 4, you must have at least 4 columns
=vlookup(a1,sheet1!a1:d863,4,false) -- HTH RP (remove nothere from the email address if mailing direct) "Pierre Fichaud" wrote in message ... =vlookup(a1,sheet1!a1:b863,4,false) I get #REF. I want the value in the 4th column in sheet1 to be inserted in the cell when any of A1 to b863 match a1. PF. Bob Phillips wrote: =VLOOKUP(A1,Sheet2!A1:B100,2,FALSE) -- HTH RP (remove nothere from the email address if mailing direct) "Pierre Fichaud" wrote in message ... I have 2 sheets, The first sheet has coulmns 1 with a name and column 2 with a value. The second sheet has column 1 with a name and other columns. Using the name in sheet2, I want to find an exact match with a name in column1 of sheet1 and then move the corresponding value in column 2 of shhet 1 to sheet2. I think this can de done with VLOOKUP but I can't get past the second parameter. Can someone help me with this? TIA. PF. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) | |||
VLookup Question | Excel Worksheet Functions | |||
question about vlookup | Excel Worksheet Functions | |||
Vlookup Question | Excel Discussion (Misc queries) | |||
vlookup question | Excel Worksheet Functions |