VLOOKUP to find weeknumber

0 votes

Do you know how to parameterize the cells' format and what it can be related to?

I'm using the "," as the decimal separator and the "" as the thousands separator in my advanced settings.

Because I simply want to alter the format of the cells, I would like not to use a formula. For now, I've created a "mirror" page using =ROUND(Cell/1000000;0) to display Millions, which is a workaround that's not very satisfactory. Currently, I get #N/A as the return.

enter image description here

If there is a way to have the cell look in the red region for a value that matches 1/1/23 (formatted as a custom format to only show the day number), then return the value in column 1, I'm going to assume there is one (the week number)


O25:O36 in my instance is simply 1/1/23:1/12/23. Just referencing the neighboring cell for O, N25:N36 are identical.

If there is a simpler way to have a cell return the weeknumber for the first day of every month, please let me know so I can put a cell on the front! based on the value in =Front, return the week number! That would be nice as well.

Feb 16, 2023 in Others by narikkadan
• 63,420 points
557 views

1 answer to this question.

0 votes

Use  ISOWEEKNUM with the dates of the first of the month has resolved.

=ISOWEEKNUM("1/1/23")
answered Feb 16, 2023 by Kithuzzz
• 38,010 points

Related Questions In Others

0 votes
1 answer

How to find the time complexity of a program?

Hi@akhtar, The first loop is O(N) and the ...READ MORE

answered Oct 15, 2020 in Others by MD
• 95,440 points
1,003 views
0 votes
0 answers

How to find the username of the instance launched in amazon-ec2?

I m having trouble connecting to the ...READ MORE

Apr 4, 2022 in Others by Kichu
• 19,050 points
1,037 views
0 votes
0 answers

How to find the username of the instance launched in amazon-ec2?

I m having trouble connecting to the ...READ MORE

Apr 5, 2022 in Others by Kichu
• 19,050 points
262 views
0 votes
1 answer

How to find out if an item is present in an std::vector?

The most straightforward solution is to count the total number of elements in the vector that have the specified value.  If the count is greater than zero, we've found our element.  This is simple to accomplish with the std::count function. #include <iostream> #include <vector> #include <algorithm> int main() { ...READ MORE

answered May 27, 2022 in Others by Damon
• 4,960 points
11,000 views
0 votes
1 answer

Using Excel VLOOKUP() function across two sheets

The syntax for VLOOKUP is VLOOKUP(Lookup_Value,Table Array,Col_index_num,Range_lookup) OR, to start in ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 63,420 points
745 views
0 votes
1 answer

Convert three letter country codes to full country names

Just create a list to be used in ...READ MORE

answered Oct 16, 2022 in Others by narikkadan
• 63,420 points
540 views
0 votes
1 answer

How to categorize/classify numbers from different ranges using Excel?

I wouldn't advise utilizing nested IFs because ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,420 points
2,855 views
0 votes
1 answer

Using VLOOKUP()

Vlookup takes the lookup value first, so ...READ MORE

answered Nov 5, 2022 in Others by narikkadan
• 63,420 points
333 views
0 votes
1 answer

Excel VBA: how to find a description from an AD-group

First add the 'description' property to your ...READ MORE

answered Feb 16, 2023 in Others by Kithuzzz
• 38,010 points
541 views
0 votes
1 answer

How to assign assign condition using if statement and VLOOKUP?

You can use either XLOOKUP() or INDEX() with MATCH() Function. • Formula used in ...READ MORE

answered Mar 26, 2023 in Others by Kithuzzz
• 38,010 points
182 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP