Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a dynamic IF statement
I have data in two sheets. I want to create an IF statement in the second
sheet that has the ability to scan the first sheet for a value. If it finds a match to a value in the second sheet, deposit the value into the corresponding cells of sheet two. My example: Sheet 1 User B 12/10 User C 12/15 Sheet 2 User A User B In this example, I will have the IF statement in column B of Sheet 2. I want the IF statement to scan column A in sheet 1 for matches to column A of sheet 2. If it finds a match, place the corresponding value in column B (in this case, it would find a match in User B and deposit 12/10 in column B of sheet 2. If it does not find a match, it leaves column B blank. I can create a static IF link from sheet 2 to sheet 1; however, the populations of sheets 2 and 1 are different. In addition, the populations of sheets 2 and 1 will be ever changing, thus, I need to be able to create the dynamic IF statements. Would I nest a VLOOKUP in the IF statement to get this done, or is there another function that I should use? -- Robert Robinson |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a dynamic IF statement
What is wrong with =VLOOKUP(A1,Sheet1!A:B,2,FALSE)
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Robert Robinson" wrote in message ... I have data in two sheets. I want to create an IF statement in the second sheet that has the ability to scan the first sheet for a value. If it finds a match to a value in the second sheet, deposit the value into the corresponding cells of sheet two. My example: Sheet 1 User B 12/10 User C 12/15 Sheet 2 User A User B In this example, I will have the IF statement in column B of Sheet 2. I want the IF statement to scan column A in sheet 1 for matches to column A of sheet 2. If it finds a match, place the corresponding value in column B (in this case, it would find a match in User B and deposit 12/10 in column B of sheet 2. If it does not find a match, it leaves column B blank. I can create a static IF link from sheet 2 to sheet 1; however, the populations of sheets 2 and 1 are different. In addition, the populations of sheets 2 and 1 will be ever changing, thus, I need to be able to create the dynamic IF statements. Would I nest a VLOOKUP in the IF statement to get this done, or is there another function that I should use? -- Robert Robinson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a dynamic IF statement
I think you can do something like this:
=IF(ISNA(MATCH(A2,'Sheet 1'!A:A,0)),"",VLOOKUP(A2,A:B,2,FALSE)) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Robert Robinson" wrote: I have data in two sheets. I want to create an IF statement in the second sheet that has the ability to scan the first sheet for a value. If it finds a match to a value in the second sheet, deposit the value into the corresponding cells of sheet two. My example: Sheet 1 User B 12/10 User C 12/15 Sheet 2 User A User B In this example, I will have the IF statement in column B of Sheet 2. I want the IF statement to scan column A in sheet 1 for matches to column A of sheet 2. If it finds a match, place the corresponding value in column B (in this case, it would find a match in User B and deposit 12/10 in column B of sheet 2. If it does not find a match, it leaves column B blank. I can create a static IF link from sheet 2 to sheet 1; however, the populations of sheets 2 and 1 are different. In addition, the populations of sheets 2 and 1 will be ever changing, thus, I need to be able to create the dynamic IF statements. Would I nest a VLOOKUP in the IF statement to get this done, or is there another function that I should use? -- Robert Robinson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating dynamic chart from within VB6 | Charts and Charting in Excel | |||
Creating Dynamic Spreadsheets | Excel Discussion (Misc queries) | |||
Creating a dynamic list | Excel Worksheet Functions | |||
Creating a dynamic chart | Charts and Charting in Excel | |||
Creating a dynamic list | Excel Worksheet Functions |