May 20 2021 11:09 AM - edited May 20 2021 11:22 AM
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)
May 20 2021 11:24 AM
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.