Example of what I am wanting to achieve with this combination of functions in Microsoft Excel:
If contents of C3 appear anywhere in range on "Extract" worksheet ("Extract" is the name of one of the worksheets in my spreadsheet) then perform the VLookup function. Otherwise return 'Not in Functional Results' in the cell that contains this formula.
Value Lookup - look up value in C3 (on this worksheet) in the specified range on Extract worksheet. Return the value in the 6th cell of the column (of the range specified). Use FALSE for exact lookup and TRUE for approximate match.
=IF(ISNA(MATCH(C3,Extract!$C$2:$C$5000,0)=0)=TRUE,"Not in Functional Results",VLOOKUP(C3,Extract!$C$2:$H$5000,6,TRUE))
