lol

hi all i have got this far with the formula =IFERROR(VLOOKUP(B8,P8:Q1265,2,FALSE),"ERROR! ") I would really like to not show the "ERROR!" until there is a number in Cell B8 is there a way to do this? Hopefully i have explained what i need lol (Trying to learn so please be nice lol) Thanks...

Problem is that filtering is complicated. Example: USER 1 - VALUE 1 - LOL USER 1 - VALUE 1 - LOL USER 1 - VALUE 1 - NOTLOL USER 1 - VALUE 3 - LOL USER 1 - VALUE 3 - LOL USER 1 - VALUE 3 - NOTLOL So for every VALUE, if NOTLOL appears, change all LOLs for this VALUE for this USER for NOTLOLs...

Hi guys...just getting into excel. Loving it so far but keep hitting walls lol.. What im trying to do is this....... I want to be able to type in the size of material,then select gauge from a dropdown box then select the the quantity from another drop down box then excel to work a price out...

I'm trying to do a works Rota with let's say 3 people starting at 6 oclcok 5 at 7 oclcok and 1 at 8 o'clock but I want to know the formula . Also I want it as 06:00 07:00 08:00 on the Rota so it's easier to see. 1/3/18 2/3/18 3/3/18 etc Person 1 06:00 Person 2...

I have a variable string which can be "test test" "test asdasd" "aa lol" The space between the word can vary from 1 space to unlimited space. What is the quick way in VBA for me to change the variable string so that there is only 1 space between the words. e.g it becomes "test test"...

Hey guys - Need help here. kinda new here. I need a formula to identify pairs with a +/- 1. Example: I'm looking for a pair with value of 100 but the only thing I have is 97,98,99 and 101. I need a formula where 100 will still be matched with the values 99 and 101. Let me know if I'm still...