Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VALUE FROM DIFFERENT SHEET
Hi can anyone help me with this formula,
I am trying to MATCH 2 worksheets; SHEET 1 has the main information and SHEET 2 has half of the infomation but that half matches the information in SHEET 1. How can I give the values to the SHEET 2 using the information that i have in sheet 1? I don know if that is clear. sheet 1 (from B2:C9) A 5 B 4 C 5 F 4 G 5 J 4 L 5 Q 4 sheet 2(from B2:C5) A ? F ? J ? Q ? Many Thakns, Juan Pablo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VALUE FROM DIFFERENT SHEET
try this
in sheet 2 cell C2 type =VLOOKUP(B2,Sheet1!B2:C9,2,FALSE) copy this down. see sheet 2 what happens? "juanpauk" wrote in message oups.com... Hi can anyone help me with this formula, I am trying to MATCH 2 worksheets; SHEET 1 has the main information and SHEET 2 has half of the infomation but that half matches the information in SHEET 1. How can I give the values to the SHEET 2 using the information that i have in sheet 1? I don know if that is clear. sheet 1 (from B2:C9) A 5 B 4 C 5 F 4 G 5 J 4 L 5 Q 4 sheet 2(from B2:C5) A ? F ? J ? Q ? Many Thakns, Juan Pablo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
Copying cells from on sheet to another sheet (via sheet module) | Excel Programming | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |