Hey Everyone,
I'm trying to come up with a way to populate a cell based on if the majority of a column is a number that would vlookup data from another sheet.
What I'm trying to accomplish is if I filter the data in column N, this data is associated with a "vendor name" on another sheet. I'm wondering if it's possible to have cell Q3 return the "vendor name" of the filtered data in column N. This may be like a subtotal function but with text.
LOGIC:
IF all data (filtered) in column N = the number in column B on Sheet 2, then return (Vlookup) "vendor name" from column A on sheet 2 to cell Q3.
Hope that makes sense..
I'm trying to come up with a way to populate a cell based on if the majority of a column is a number that would vlookup data from another sheet.
What I'm trying to accomplish is if I filter the data in column N, this data is associated with a "vendor name" on another sheet. I'm wondering if it's possible to have cell Q3 return the "vendor name" of the filtered data in column N. This may be like a subtotal function but with text.
LOGIC:
IF all data (filtered) in column N = the number in column B on Sheet 2, then return (Vlookup) "vendor name" from column A on sheet 2 to cell Q3.
Hope that makes sense..