VLOOKUp Question (Multiple Worksheets, Multiple Columns)

%3CLINGO-SUB%20id%3D%22lingo-sub-2373145%22%20slang%3D%22en-US%22%3EIFTHEN%20Question%20(Multiple%20Worksheets%2C%20Multiple%20Columns)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2373145%22%20slang%3D%22en-US%22%3E%3CP%3EIts%20been%20a%20while%20since%20I've%20done%20this%20and%20I'm%20having%20a%20block.%26nbsp%3B%20%26nbsp%3BI%20have%20two%20work%20sheets%2C%20and%20I%20need%20an%20IF%20THEN%20for%20values%20from%20multiple%20worksheets%20multiple%20columns.%26nbsp%3B%20For%20simplicity%20lets%20say%20Worksheet%20A%20and%20Worksheet%20B.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorksheet%20A%20has%20a%20Date%20field%3C%2FP%3E%3CP%3EWorksheet%20B%20has%20a%20column%20with%20the%20Dates%20(Column%20A)%20and%20a%20column%20for%20a%20corresponding%20name%20(Column%20B).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20need%2C%20is%20a%20formula%20that%20says%20%22If%20the%20date%20in%20Worksheet%20A%20equals%20the%20date%20in%20Column%20A%20of%20Worksheet%20B%2C%20then%20the%20value%20equals%20the%20name%20in%20Column%20B%20of%20Worksheet%20B%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20this%20make%20sense.%26nbsp%3B%20(Screen%20Shots%20Attached)%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2373145%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2373247%22%20slang%3D%22en-US%22%3ERe%3A%20IFTHEN%20Question%20(Multiple%20Worksheets%2C%20Multiple%20Columns)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2373247%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1059276%22%20target%3D%22_blank%22%3E%40rnelsch%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20B2%20on%20Worksheet%20A%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(A2%2C%20'Worksheet%20B'!%24A%242%3A%24B%24100%2C%202%2C%20FALSE)%2C%20%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EVLOOKUP%20does%20the%20work%20here.%20Replace%20Worksheet%20B%20with%20the%20real%20name%20of%20your%20sheet%2C%20and%20adjust%20the%20range%20if%20necessary.%3C%2FP%3E%0A%3CP%3EIFERROR%20is%20used%20to%20suppress%20the%20%23N%2FA%20error%20you'd%20get%20if%20there%20is%20no%20matching%20date.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20fill%20the%20formula%20down%20if%20you%20have%20more%20dates%20in%20column%20A%20of%20Worksheet%20A.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Its been a while since I've done this and I'm having a block.   I have two work sheets, and I need a VLookUp for values from multiple worksheets multiple columns.  For simplicity lets say Worksheet A and Worksheet B.  

 

Worksheet A has a Date field

Worksheet B has a column with the Dates (Column A) and a column for a corresponding name (Column B).  

 

What I need, is a formula that says "If the date in Worksheet A equals the date in Column A of Worksheet B, then the value equals the name in Column B of Worksheet B"

 

Does this make sense.  (Screen Shots Attached)    

 

1 Reply

@rnelsch 

In B2 on Worksheet A:

 

=IFERROR(VLOOKUP(A2, 'Worksheet B'!$A$2:$B$100, 2, FALSE), "")

 

VLOOKUP does the work here. Replace Worksheet B with the real name of your sheet, and adjust the range if necessary.

IFERROR is used to suppress the #N/A error you'd get if there is no matching date.

 

You can fill the formula down if you have more dates in column A of Worksheet A.