Search results

Good afternoon!!! I have a report where I need to add a Y/N based on the name of the account. tab1:Col a acct no, Col b name of account Col C Y/N tab2:Col a-name of account I've tried to do a vlookup formula, a match formula and an index formula and I can't get any to work. Here is where...

Hui, you rock my world! Just when I think I have a handle on this excel thing, this group just BLOWS MY MIND!!!!! Thank you so much....I have much to learn...

Thank Hui...I'm not sure how that formula works. Would you mind explaining? When I put that formula on my summary tab I got a #REF error. Maybe I wasn't clear..instead of doing the 2 SUMIF formulas in each monthly tab, I want to do it on the summary tab (one in each line for each month). Does...

Greetings to all! I have an excel workbook that has 12 tabs (1 for each month) and a summary tab. IN each of the 12 tabs I've done 2 SUMIF formulas to get 2 different numbers and then in the SUMMARY tab just did an = to pull that value over... Is there a way to do the actual SUMIF in the...

Thanks to both of you. Dan, I did check out that article before I posted and couldn't get the formula to work. Narayank991, this works perfectly. My confusion is not knowing when to use what formula...Thanks again for all of your expertise!!!!

Hi All, I'm needing to create a Y/N column in a report based on a name in one of the columns. The name, however, is spelled differently. I was trying to do a VLookup with a wildcard, but I can't get it to work. Here is a mock up of the file and formula (incorrect) is there as well. I'm not sure...

Thank you Hui!

This has certainly been my week for questions. The one for today I actually had figured out earlier in the week but my brain for some reason is not working right now. I have a file that contains acct number, code 1 and code 2. I need to set up a 4th column with a Yes/No function. If code 1 and...

This has been nothing short of fabulous. I'm so indebted to this site. I've learned so much and there's so much more to learn...THANK YOU!!!!! This works perfectly! I can do this in access but I'm really pushing myself to learn excel to get my certification.....

I had a blast today doing VLOOKUPs at work. But now I've run into a snag. I tried to do sort of a backwards VLOOKUP (if there is such a thing). I have compare a file where the C column DOESN'T match the A column. When I run my VLOOKUP I get the name where there is a match and a #NA where there...

Thank you Hui,,you are a most excellent excel ninja....I totally had that vlook up backwards....made it more complicated than it needed to be....Thank you!!!!!

I have an excel workbook. Sheet 1 is a data tab and sheet 2 has the fee revenue ( I named it a lookup table). I want to move the fee revenue to a column in the data sheet. I'm using a VLookup function and obviously it's not working. The link to the example is...

Thank you! Thank you! Thank you!......totally worked!...I guess I'll be taking the Chandoo.org excel class...need to learn more aboutformulas....again, Thanks so much!

Thank you SirJB7...I have a question. I've been at this for about 4 hours and that's not a problem because that's how I learn. I totally get the formula's in Aux1 and 2 columns. I'm not sure about how the VLookup in the unique column works. It seems to delete out the duplicates which throws off...

I'm fairly new to excel formulas. I have a table that where a region may have more than 1 code which creates duplicates. Is there a formula in excel where I could move the 2nd code into a new column in the table? or move them to a separate column? Thanks in advance!!!!! Jaimee (hopefully this...

My name is Jaimee. I'm pretty much self taught in excel and have just started to take online classes to help myself along. I love this site!