Jonathan Meyer
New Member
- Joined
- Dec 21, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hoping someone can assist with the below query.
I am trying to do a v or x lookup between 2 workbooks with the following scenario. The workbook I am trying to get the lookup result from has 3 columns.
Column A: Has data that matches exactly in both the workbook I am typing the formula in and where I am trying to get the lookup result from.
Column B: Has data that matches approximately 70-90% between the 2 workbooks.
Column C: Is the data I am trying to lookup and bring from one work book into another.
On its own Column A is not enough to do the lookup on, as it is not unique enough to deliver the unique Column C. (ie Column A and C are not a one to one relationship)
I tried doing a partial or fuzzy lookup by combining Columns A & B, but the results were still not great. Nether was putting the data in power query to do a fuzzy search.
I was hoping there was a formula to do the following;
Find all instances of a label in Column A, and then do the partial or fuzzy lookup for just those rows with that instance in Column's B & C.
So if Column A was hundreds of rows with say month names, can I do a x or v lookup on Column B to find column C, but only lookup rows in Column A with a specific value in them, (Say January), and all other rows with other month names in the data set would not be part of the lookup.
I am trying to do a v or x lookup between 2 workbooks with the following scenario. The workbook I am trying to get the lookup result from has 3 columns.
Column A: Has data that matches exactly in both the workbook I am typing the formula in and where I am trying to get the lookup result from.
Column B: Has data that matches approximately 70-90% between the 2 workbooks.
Column C: Is the data I am trying to lookup and bring from one work book into another.
On its own Column A is not enough to do the lookup on, as it is not unique enough to deliver the unique Column C. (ie Column A and C are not a one to one relationship)
I tried doing a partial or fuzzy lookup by combining Columns A & B, but the results were still not great. Nether was putting the data in power query to do a fuzzy search.
I was hoping there was a formula to do the following;
Find all instances of a label in Column A, and then do the partial or fuzzy lookup for just those rows with that instance in Column's B & C.
So if Column A was hundreds of rows with say month names, can I do a x or v lookup on Column B to find column C, but only lookup rows in Column A with a specific value in them, (Say January), and all other rows with other month names in the data set would not be part of the lookup.