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


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.