Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup, match?
I have a value in column A on sheet 3, I want it to match a value in column A
in sheet 1, then I want the corresponding number from column c on sheet 1 to populate column c on sheet 3. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup, match?
Perhaps this in column C sheet 3
=VLOOKUP(A1,Sheet1!A1:C30,3,FALSE) Mike "jkb66" wrote: I have a value in column A on sheet 3, I want it to match a value in column A in sheet 1, then I want the corresponding number from column c on sheet 1 to populate column c on sheet 3. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup, match?
In C1:
=VLOOKUP(A1,Sheet1!A1:C5,3,FALSE) -- Kind regards, Niek Otten Microsoft MVP - Excel "jkb66" wrote in message ... |I have a value in column A on sheet 3, I want it to match a value in column A | in sheet 1, then I want the corresponding number from column c on sheet 1 to | populate column c on sheet 3. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup, match?
"jkb66" wrote in message
... I have a value in column A on sheet 3, I want it to match a value in column A in sheet 1, then I want the corresponding number from column c on sheet 1 to populate column c on sheet 3. To get you started, in cell C1 of Sheet3 put this formula: =VLOOKUP(A1,Sheet1!A1:C999,3,0) (Adjust the range A1:C999 to suit your data.) Copy it down as far as you need for data in Sheet 3. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup, match?
Thank you all that did help part 1 of a 2 part problem!,
same workbook. sheet 3 I have a value in column b that I need to match in sheet 2 and bring the corresponding value in column b and populate into sheet 3 column d, I had thought I could manipulate these VLookups to suit purpose, but I keeping getting #REF! "Stephen" wrote: "jkb66" wrote in message ... I have a value in column A on sheet 3, I want it to match a value in column A in sheet 1, then I want the corresponding number from column c on sheet 1 to populate column c on sheet 3. To get you started, in cell C1 of Sheet3 put this formula: =VLOOKUP(A1,Sheet1!A1:C999,3,0) (Adjust the range A1:C999 to suit your data.) Copy it down as far as you need for data in Sheet 3. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup, match?
Just to add...
If you're going to copy the formula down the column, make sure that the lookup table range doesn't change: =VLOOKUP(A1,Sheet1!A1:C999,3,0) should be: =VLOOKUP(A1,Sheet1!$A$1:$C$999,3,0) or if there's nothing else in A:C, you could use the whole column: =VLOOKUP(A1,Sheet1!$A:$C,3,0) jkb66 wrote: I have a value in column A on sheet 3, I want it to match a value in column A in sheet 1, then I want the corresponding number from column c on sheet 1 to populate column c on sheet 3. -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup, match?
Thank you this has been solved!
"jkb66" wrote: Thank you all that did help part 1 of a 2 part problem!, same workbook. sheet 3 I have a value in column b that I need to match in sheet 2 and bring the corresponding value in column b and populate into sheet 3 column d, I had thought I could manipulate these VLookups to suit purpose, but I keeping getting #REF! "Stephen" wrote: "jkb66" wrote in message ... I have a value in column A on sheet 3, I want it to match a value in column A in sheet 1, then I want the corresponding number from column c on sheet 1 to populate column c on sheet 3. To get you started, in cell C1 of Sheet3 put this formula: =VLOOKUP(A1,Sheet1!A1:C999,3,0) (Adjust the range A1:C999 to suit your data.) Copy it down as far as you need for data in Sheet 3. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I lookup when match has more than one value? | Excel Worksheet Functions | |||
match, lookup ??? | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Lookup Match | Excel Worksheet Functions | |||
Lookup or Match | Excel Worksheet Functions |