FinancialAnalystKid
Well-known Member
- Joined
- Oct 14, 2004
- Messages
- 779
I have three columns in a spreadsheet and need to match these three columns to three columns in another sheet. If it matches, I want to retrieve the value in the a 4th column. Is this possible?
I was concatenating the three columns on both sheets in order to use vlookup but would like to do this without a macro and without adding more columns to the sheet.
I can't figure it out.
I was concatenating the three columns on both sheets in order to use vlookup but would like to do this without a macro and without adding more columns to the sheet.
I can't figure it out.