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 |
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 |
All times are GMT +1. The time now is 01:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com