Excel Help and Problems

[MarkS]

Don't know anything about that. But I can take a look.

Really quick response by the way.

Google it to understand it better, but basically, if Sheet A had SKU in Column A and description in Column B, And Sheet 2 had SKU in column A and you want to put the description in column B, in B1 put =vlookup(A1,Sheet1!A:B,2,false)  and drag it down to fill the other rows.
2

[HowYaDoin]

Ok. time for a complicated formula request. (if its even possible)

I have two excel sheets with lists of products. Sheet A has the products descriptions and Sheet B doesn't. I want sheet B to compare SKU's in column B with sheet A and if they match to copy a specific cell from Sheet A to Sheet B.

Possible?

Yup I agree with MarkS sounds like a typical Vlookup. Very useful formula to learn

[skyguy918]

Yup I agree with MarkS sounds like a typical Vlookup. Very useful formula to learn

Booooo... INDEX-MATCH, FTW!

[aygart]

Booooo... INDEX-MATCH, FTW!

True, but for someone who did not realize that vlookup even exists the syntax will be simpler.

[Zevi16]

Google 'excel convert time to decimal' - that's what you need to do, I'm pretty sure its by dividing by 60.
You also want to make sure excel knows if its am or pm, i.e. use the correct formatting.

Thanx I'll try.

[HowYaDoin]

Booooo... INDEX-MATCH, FTW!

After Googling you are probably correct. That definitely is something i will have to try one of these days. The fact that  INDEX-MATCH can be done right to left is a game changer

[churnbabychurn]

Booooo... INDEX-MATCH, FTW!

I love index match. -much more flexible than vlookup..
But is there an approximate match option? Seems to be either exact/more/less.
Also, does index match work with duplicate matches to return both?

[skyguy918]

I love index match. -much more flexible than vlookup..
But is there an approximate match option? Seems to be either exact/more/less.
Also, does index match work with duplicate matches to return both?

Not sure what you mean by approximate. There are certainly no other options (-1, 0, 1), but you should be able to pick up the appropriate values with one of those options on most scenarios.

Duplicates only comes up with the exact match option, and it will return the first position in the vector that matches, thereby ignoring any others. There are (fairly tedious) ways around this.

Eta: If you give specific examples for your 2 questions I can try to formulate solutions, but a lot of times it ends up being way more complex than just the INDEX-MATCH.

[MarkS]

I love index match. -much more flexible than vlookup..
But is there an approximate match option? Seems to be either exact/more/less.
Also, does index match work with duplicate matches to return both?

Aha! V lookup has the approximate match option! (True/false)

[churnbabychurn]

Not sure what you mean by approximate. There are certainly no other options (-1, 0, 1), but you should be able to pick up the appropriate values with one of those options on most scenarios.

Looking up cells containing text description or names that have slight variations would work better in vlookup then.

Duplicates only comes up with the exact match option, and it will return the first position in the vector that matches, thereby ignoring any others. There are (fairly tedious) ways around this.

Eta: If you give specific examples for your 2 questions I can try to formulate solutions, but a lot of times it ends up being way more complex than just the INDEX-MATCH.

I'm sure there are solutions but I do this very often these days with various data sets..- custom solutions wouldn't work..wish it would just work.

[yitzf]

I'm sure there are solutions but I do this very often these days with various data sets..- custom solutions wouldn't work..wish it would just work.

Creating a pivot table first should take care of duplicates (if you want to add them...)

[yitzf]

Looking up cells containing text description or names that have slight variations would work better in vlookup then.

Approximate only works for a sorted number range not text.

You could use wildcards in vlookup to help with slight variations.

[yitzf]

Just found this add-in from Microsoft https://www.microsoft.com/en-us/download/details.aspx?id=15011

It's called Fuzzy Lookup.

Has anyone used this before?
I can't believe I never heard of it...

[churnbabychurn]

Creating a pivot table first should take care of duplicates (if you want to add them...)

They are not really duplicates.. Need to keep both.

[yitzf]

They are not really duplicates.. Need to keep both.

If most of the items are unique and only a few are duplicates, you can attach a countif to the vlookup to check for duplicates, them manually work on the duplicates.

[dave]

Trying to do a mail merge for envelopes but can't seem to find princess size envelopes called A1
any help ?

[lechatchileh ariber]

Taking ajk into consideration, I'm trying to make this table. Is there any way that I can organize this so that I can make column 'E' automatic, or  should I leave it as manual?

[lubaby]

Taking ajk into consideration, I'm trying to make this table. Is there any way that I can organize this so that I can make column 'E' automatic, or  should I leave it as manual?

Excel is extremely proficient at math.

In E2, enter =B2-C2 (assuming that's what you want to calculate).

[lechatchileh ariber]

Excel is extremely proficient at math.

In E2, enter =B2-C2 (assuming that's what you want to calculate).

For the same price I can write 9578 in E5.
I'm wondering if there's a way I can organize it that when I add a new event I can have a total automatically without having to input in the 'total' column.
Eta: this might be a little clearer.

Is there a way organize this that i can have an automatic total every time I add a row with new information?

[churnbabychurn]

For the same price I can write 9578 in E5.
I'm wondering if there's a way I can organize it that when I add a new event I can have a total automatically without having to input in the 'total' column.
Eta: this might be a little clearer.

Is there a way organize this that i can have an automatic total every time I add a row with new information?

Yes. organize it as a table and it should to it automatically.