Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF & VLOOKUP
Hi,
I am a total beginner in Excel, VLOOKUPS etc. I want to do the following but I am not too sure of the syntax. Help would be greatly appreciated. I have 2 workbooks. In workbook A I have a date, an account number and some information in workbook B I have a date, an account number and the need to take information from workbook A and insert it into workbook B I have also got the following but it's not working..This is in Workbook A =IF((C8<'WORKBOOK B'!A2),VLOOKUP(D8,'WORKBOOK B'!$A:$D,2,FALSE)) Basically, I need the dates to match in order to look up the account number with the V lookup and give me the data next to the account number. Where am I going wrong? Many thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF & VLOOKUP
You need to have the formula in worksheet B to "pull" data from
worksheet A, and you also want to match on both the date AND the account number. In worksheet A, insert a new column C and in C2 enter this formula: =A2&B2 This joins the two columns together to form a unique key. Copy this formula down column C for as many data items as you have (assume this is 500). Then in column C of worksheet B enter this formula in C2: =VLOOKUP(A2&B2,'worksheet A'!C$2:D$500,2,0) and copy this formula down column C for as many items as you have in columns A and B. Hope this helps. Pete Dr Phibes wrote: Hi, I am a total beginner in Excel, VLOOKUPS etc. I want to do the following but I am not too sure of the syntax. Help would be greatly appreciated. I have 2 workbooks. In workbook A I have a date, an account number and some information in workbook B I have a date, an account number and the need to take information from workbook A and insert it into workbook B I have also got the following but it's not working..This is in Workbook A =IF((C8<'WORKBOOK B'!A2),VLOOKUP(D8,'WORKBOOK B'!$A:$D,2,FALSE)) Basically, I need the dates to match in order to look up the account number with the V lookup and give me the data next to the account number. Where am I going wrong? Many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |