Greetings,
I have the following vlookup: =VLookupAll(G4, 'AO Objects'!$A$2:$A$14306, 1)
I am needing to ensure the data I am looking for also matches an additional data point in column F4. The targeted data would contain both the G4 and the F4 data, but it is possible the G4 is in another location but not matching F4.
Hope I explained that. Data for the F4 data in the target tab (AO Objects) is in E4
so both have to be together for a match
Thanks,
Brad
Vlookup assistance
-
- 4StarLounger
- Posts: 540
- Joined: 30 Mar 2010, 18:49
- Location: United States
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Vlookup assistance
Which version of Excel do you have? (And if the workbook is to be used by others: what is the oldest version you need to support?)
What exactly do you mean by " Data for the F4 data in the target tab (AO Objects) is in E4"?
What exactly do you mean by " Data for the F4 data in the target tab (AO Objects) is in E4"?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 540
- Joined: 30 Mar 2010, 18:49
- Location: United States
Re: Vlookup assistance
We are using O365.
I will have to get you a sample on Thursday.
I will have to get you a sample on Thursday.