Vlookup assistance

bradjedis
4StarLounger
Posts: 536
Joined: 30 Mar 2010, 18:49
Location: United States

Vlookup assistance

Post by bradjedis »

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

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Vlookup assistance

Post by HansV »

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"?
Best wishes,
Hans

bradjedis
4StarLounger
Posts: 536
Joined: 30 Mar 2010, 18:49
Location: United States

Re: Vlookup assistance

Post by bradjedis »

We are using O365.

I will have to get you a sample on Thursday.