Hello, Can you please help me with the correct code for these conditions: In worksheet one, need to pull in the results of Yes or No from a different worksheet (two) in the same Google Spreadsheet if the condition is met that the Startup name matches exactly in both worksheets and a "Yes" or "No" is in column L to be accepted into a program.
Worksheet 1 column Q2:Q400 range must match worksheet 2 column C2:C400 for startup name and
Worksheet 2 column L2:L400 has a Yes or No response which is pulled into Worksheet 1 column AD2:AD400
(perhaps a vlookup needs to be used as well as countif)
Any help would be appreciated!
Worksheet 1 column Q2:Q400 range must match worksheet 2 column C2:C400 for startup name and
Worksheet 2 column L2:L400 has a Yes or No response which is pulled into Worksheet 1 column AD2:AD400
(perhaps a vlookup needs to be used as well as countif)
Any help would be appreciated!
Last edited by a moderator:
