VLOOKUp Question (Multiple Worksheets, Multiple Columns)

Occasional Contributor

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.