Skip to main content
Super User

Questions tagged [lookup]

Ask Question

The tag has no summary.

141 questions
Newest Active Bountied Unanswered
0 votes
1 answer
60 views

A23:A1000: date B23:B1000: balance (number format) C1: a specific year (number format), say 2023 How do I find the value of B based on the last cell in A with year C1? I tried various forms of LOOKUP ...
Art's user avatar
  • 3
0 votes
0 answers
306 views

I'm scratching my head around this. I don't know if what I'm trying is even possible in Excel (2021 version) without VAB. On one hand, I've got a table like this, called "temario": enter ...
Alejandro González Espejo's user avatar
  • 53
0 votes
3 answers
87 views

From the picture below, I'm trying to get a return of either T1 T2 T3 (in Green) based on the Final value from the left table and its corresponding tier, from the right table and the tier criteria/...
Jereme Chong's user avatar
  • 1
0 votes
0 answers
71 views

I am scraping data from a site and pulling data from this dump to another sheet. The dump creates files with 2 columns, one with a date and timestamp in 15 minute intervals, and the second column is ...
George R's user avatar
  • 1
0 votes
2 answers
71 views

I'm using formula LOOKUP in EXCEL 2013 as shown below: =LOOKUP(1,0/(($B3=Master!$A:$A)*(F$2=Master!$B:$B)),Master!$C:$C,"") But now it's jump out said I entered too many arguments for this ...
Alicia Phua Wan Chien's user avatar
  • 1
0 votes
1 answer
79 views

I am trying to work on this for quite a few days for now. I want to take out the middle names from last name. I have possible list of middle names and a list of last names. I am trying to look up the ...
Novice's user avatar
  • 1
0 votes
1 answer
633 views

The VLOOKUP works as intended. The XLOOKUP is giving "#NAME" error: screenshot of the formula: the working VLOOKUP: =VLOOKUP(C12,B24:C29,2,FALSE) Which I'm reading as "take the ...
Nick's user avatar
  • 5
0 votes
2 answers
674 views

I am looking to try and work out how to get a return from a table, depending on what it is that you enter. As an example I have included an image of how the table might look. I have a range of 5 ...
PBA24's user avatar
  • 3
-1 votes
1 answer
46 views

I have one cell that calculates a figure based on 2 cells, so for example target quantity is in C6 then the completed quantity is in D6 so cell E6 is "=D6-C6" but i only want it to ...
Tracy's user avatar
  • 1
0 votes
2 answers
3k views

I have a list of values in one table (Artist), that I then want to find a partial match to be used to populate a second value (Genre) from a separate table. If it cannot find a match, then leave the ...
Dean's user avatar
  • 19
1 vote
1 answer
109 views

I have two ranges on the same sheet, we'll call them Range A and Range B. These ranges are the same size and their location on a sheet is known. I ultimately need to find a value in Range B. To start ...
Lost_Llama's user avatar
  • 35
2 votes
1 answer
225 views

I try to access subdomain.a.com which uses dns.b.com for DNS but that DNS-server (all 10 of them actually) is down since about 2 hours. subdomain.a.com is working as expected but you just can't access ...
d-b's user avatar
  • 966
0 votes
3 answers
103 views

What Excel formula can I write so it will look for the same project in Column B in Column I and place the YTD matching the project from Column J in Column C in the table below? A B ...
Lulu's user avatar
  • 1
0 votes
1 answer
688 views

I have a complicated Excel worksheet, but I will simplify what I need in a simple scenario. I have the following sheet as raw data. Also, I have another sheet where I can select the student's name ...
attavip's user avatar
  • 7
0 votes
1 answer
944 views

The two-way table is a table where the value of a dependent variable is dependent on two independent variables, so actually it's a mix of two one-way tables. When you lookup for a value in a two-way ...
user avatar

15 30 50 per page
1
2 3 4 5
…
10