Require assistance with the following formula/method to use the V look up tool (explained below)

%3CLINGO-SUB%20id%3D%22lingo-sub-3287918%22%20slang%3D%22en-US%22%3ERequire%20assistance%20with%20the%20following%20formula%2Fmethod%20to%20use%20the%20V%20look%20up%20tool%20(explained%20below)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3287918%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20and%20thanks%20for%20reading%20-%20really%20appreciate%20the%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20data%20located%20in%20a%20number%20of%20columns%20A%20-%20AO.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20use%20the%20IF%20or%20Vlook%20up%20function%20to%20locate%20an%20item%20within%20a%20column%20(column%20O)%2C%20and%20then%20bring%20up%20the%20corresponding%20item%20in%20column%20A%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20in%20advance%2C%20A%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3287918%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3287944%22%20slang%3D%22en-US%22%3ERe%3A%20Require%20assistance%20with%20the%20following%20formula%2Fmethod%20to%20use%20the%20V%20look%20up%20tool%20(explained%20below)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3287944%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fexceloffthegrid.com%2Fdownload%2F2663%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceloffthegrid.com%2Fdownload%2F2663%2F%3C%2FA%3E%3CBR%20%2F%3EThis%20can%20help%20you%20with%20advanced%20vlook%20up%20formulas%20-%20link%20will%20download%20a%20pdf%20cheat%20sheet%20that%20breaks%20down%20wildcards%20to%20multi%20part%20conditionals.%20-CHEERS%2C%20KS%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3287943%22%20slang%3D%22en-US%22%3ERe%3A%20Require%20assistance%20with%20the%20following%20formula%2Fmethod%20to%20use%20the%20V%20look%20up%20tool%20(explained%20below)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3287943%22%20slang%3D%22en-US%22%3EHey%20-%20unless%20I'm%20not%20understanding%20you%20correctly%20this%20will%20work%20as%20expected%3B%3CBR%20%2F%3E%3DVLOOKUP(%7Bcell%20with%20value%20I%20am%20checking%20for%7D%2C%7Bthe%20data%20range%20with%20headers%20and%20labels%20to%20check%20in%7D%2C%20%2CMATCH(%7Bsecond%20conditional%20to%20search%20by%20row%20for%7D%2C%7Bthe%20range%20to%20apply%20the%20search%20with%20no%20headers%20or%20labels%7D%2C0)%2B1%2CFALSE)%3CBR%20%2F%3EIt%20will%20preform%20what%20is%20called%20a%20two%20way%20look-up%3B%20you%20can%20achieve%20this%20with%20any%20number%20of%20lines%20or%20worksheets%20to%20make%20more%20complex%20conditionals%2C%20you%20can%20assign%20this%20to%20a%20LET%20variable%20function%20as%20well%20if%20needed%20in%20some%20but%20not%20all%20situations%20and%20apply%20IF%20AND%20NOT%20TRUE%20FALSE%20Logic%20from%20there%20-%20Hope%20this%20help%2C%20if%20unclear%2C%20look%20up%20%222-way%20look-up%20excel%20on%20google%22%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, and thanks for reading - really appreciate the help.

 

I have data located in a number of columns A - AO.

 

Is it possible to use the IF or Vlook up function to locate an item within a column (column O), and then bring up the corresponding item in column A? 

 

Many thanks in advance, A

2 Replies
Hey - unless I'm not understanding you correctly this will work as expected;
=VLOOKUP({cell with value I am checking for},{the data range with headers and labels to check in}, ,MATCH({second conditional to search by row for},{the range to apply the search with no headers or labels},0)+1,FALSE)
It will preform what is called a two way look-up; you can achieve this with any number of lines or worksheets to make more complex conditionals, you can assign this to a LET variable function as well if needed in some but not all situations and apply IF AND NOT TRUE FALSE Logic from there - Hope this help, if unclear, look up "2-way look-up excel on google"
https://exceloffthegrid.com/download/2663/
This can help you with advanced vlook up formulas - link will download a pdf cheat sheet that breaks down wildcards to multi part conditionals. -CHEERS, KS