Is there a way to use LOOKUP VLOOKUP HLOOKUP to return headers in EXCEL Current formula returning wrong value

0 votes

My Excel workbook's purpose is to schedule workers in available time blocks:

Time Sheet

and return the total number of time blocks allotted to each employee, along with the time block (column header) each employee was assigned to in the Work Overview.

[

In the work overview sheet, the column "assigned times" uses the following formula:

 =(IFERROR(LOOKUP(A3,Schedule!$B$3:$B$7,Schedule!$B$2:$B$2),"No Job Assigned"))

The goal is to search the column of cells (B3:B7) for the name in cell "A3". When if the name appears in column, the column header is returned to the Roster Sheet, next to their name (Assigned times).

Nov 6, 2022 in Others by Kithuzzz
• 38,000 points
932 views

1 answer to this question.

0 votes

Try this:

=SUMPRODUCT(--(Schedule!$B$3:$F$7=A3))
answered Nov 6, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

Is there a way to hide excel formula using Apache POI

In Excel, hiding formulae is a feature ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 63,600 points
1,260 views
0 votes
1 answer

Is there any way in python to auto-correct spelling mistake in multiple rows of an excel files of a single column?

Use Spellchecker for doing your stuff: import pandas ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 63,600 points
2,084 views
0 votes
1 answer
0 votes
0 answers

What is the best way to use a HashMap in C++?

Can someone recommend me some good documentation ...READ MORE

May 19, 2022 in Others by Kichu
• 19,040 points
476 views
0 votes
1 answer

Excel Lookup function for text

Use a simple VLOOKUP() function like: =VLOOKUP(E2,$A$2:$B$6,2,FALSE) You can also use ...READ MORE

answered Dec 13, 2022 in Others by narikkadan
• 63,600 points
575 views
0 votes
1 answer

Excel stock and sales data management

you must attach the event handler each ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
796 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,600 points
1,010 views
0 votes
1 answer

Way to overcome Excel Vlookup function limit of 256 characters

If you are using VLOOKUP like this: =VLOOKUP(A2,D2:Z10,3,FALSE) i.e. ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 63,600 points
3,548 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
• 63,600 points
686 views
0 votes
1 answer

Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 63,600 points
2,048 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