iferror

2 Topics

Vlookup for when it can't find AND when it's blank
I currently have the following formula set up =IFERROR(VLOOKUP(C163,Validator!K:L,2,FALSE),"Click to learn more") That means it looks up text in another table to find a result, and if the title in C163 isn't there it returns the value 'click to learn more.' This is great, but i would also like to add an extra layer. If C163 is blank (ie its not that the text can't be found in the lookup table, its that cell C163 is completely blank) I would like it to return an empty cell. Is that possible? How can i do that?
cblabey
Feb 15, 2019 Place Excel
1KViews
0likes
1Comment
IFERROR - HLOOKUP- IF formula error
Hello, I am trying to use excel to build an attendance consolidation sheet. Each day has 7 hours (1 through 7). The user has to fill in the absentee roll numbers (separated by comma) in the "Attendance entry sheet". This data is pulled into the "sort" sheet and separated using a TRIM-MID-SUBSTITUTE combination. The sort sheet data is used to fill up the corresponding entry in the "consolidated sheet". If a person is absent, a "0" is marked against him/her in the corresponding hour else an "x". The problem I face now is that the IFERROR - HLOOKUP- IF formula used for the purpose is giving a #Value ! error. The sample for the first two persons on Monday 1st hour is highlighted. Also I am not able to pull down the formula down the cell to replicate the same over the entire week from Monday to Friday. File attached for reference. Thank you for the patience JIM
Solved
data24365
Jul 25, 2018 Place Excel
8.2KViews
0likes
14Comments