python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
VLOOKUP retrieving data under today's month and year
So my problem is that I cannot figure out how to use VLOOKUP to get data under today's month and year.
So as seen in the pic, I have data under every month of multiple years and I need to look up the...
YSWS
Votes: 0
Answers: 1
excel can't MATCH or VLOOKUP on column with mixed text and numbers
In excel, I am trying to do a VLOOKUP or INDEX/MATCH on a column which contains some numbers and some strings of mixed numbers and letters.
It looks something like this.
In a separate sheet, I have t...
QuadB
Votes: 0
Answers: 0
Creating payroll for promotion that is based on two criteria
We have a few coaches who work for us.
When a session is booked, the data including the coach's name and student name is pushed to a master sheet.
We have criteria for promotion which is based on hour...
Sushi
Votes: 0
Answers: 1
how to fill a complete column with arrayformula and containing Vlookup of base on a single cell criterion
I need this exact formula into V1:V column
=VLOOKUP('Target Sheet'!$G$1,IMPORTRANGE("MYLIST","FileLInktoAgent!$A$2:$C$45"),2,0)
That formula works perfectly for 1 row, I want all ...
Marc Robillard
Votes: 0
Answers: 1