W
WINKIEKAT
hi i have a workbook with multiple tabs and a vlookup. Can someone
help me modify the formula to get rendered output to be from adjacent
column?
on my first tab, i have several columns with classification headings
(A = Operations B = Network C = Security...)
on my second tab I have a list of projects and corresponding
classification (A = Project Name B= Classification)
I am trying to get the Project Name to render in each column (its
classification)
so on tab 1 I would like column A to display all Operations projects,
column B to display all Network projects, etc)
my vlookup is ::: "=VLOOKUP(B7,'Candidate List'!$D$5:$D
$400,1,FALSE)" --> "Operations"
where B7 is my column for operations,
candidate list tab column D has my classifications
column 1 of candidate list tab has a the project name
I need to figure out how to modify my formula to render the project
name instead of the classification.
help me modify the formula to get rendered output to be from adjacent
column?
on my first tab, i have several columns with classification headings
(A = Operations B = Network C = Security...)
on my second tab I have a list of projects and corresponding
classification (A = Project Name B= Classification)
I am trying to get the Project Name to render in each column (its
classification)
so on tab 1 I would like column A to display all Operations projects,
column B to display all Network projects, etc)
my vlookup is ::: "=VLOOKUP(B7,'Candidate List'!$D$5:$D
$400,1,FALSE)" --> "Operations"
where B7 is my column for operations,
candidate list tab column D has my classifications
column 1 of candidate list tab has a the project name
I need to figure out how to modify my formula to render the project
name instead of the classification.