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 in Others by Kithuzzz
• 20,660 points
35 views

1 answer to this question.

0 votes

Try this:

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

Related Questions In Others

0 votes
1 answer
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 in Others by Kichu
• 19,040 points
69 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30 in Others by narikkadan
• 37,660 points
53 views
0 votes
1 answer

Excel stock and sales data management

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

answered Sep 23 in Others by narikkadan
• 37,660 points
43 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 in Others by narikkadan
• 37,660 points
61 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 in Others by narikkadan
• 37,660 points
119 views
0 votes
1 answer

lookup Data in Excel

Without VBA, it can be done in ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
48 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 in Others by narikkadan
• 37,660 points
57 views
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 in Others by narikkadan
• 37,660 points
67 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