E1.7 VLOOKUP across two worksheets

[SAEED77774]

Thank you sir. I'm rally love it.

[chocobarohenrawr]

I spent 3 hours trying to figure this out thru a text book. Then i watched your video and understood it immediately. Thanks!

[kingmaxlin]

Thanks mate, very useful

[falsestart11]

Thank you so much!

[happystanger]

Great...very well done

[DISSANAYAKE1010]

thanks for information that's really worth.

best regards.

[drwatsup]

Merci mon ami...You have helped make V-lookups much easier to understand.

[piero1255]

THANK YOU!!! You saved me from getting a 0 on my homework!

[stacydrennan]

Great help, thanks! One note that wasn't mentioned. In the second (lookup) worksheet, apparently the matching field MUST be not only sorted, as you mentioned before, but the first column. Took some amount of trial and error to figure that out for me.

[Firchild]

@stacydrennan Weird, I just tested that, and it worked in any number of columns... I have been for a while now, with multiple lookups in different columns/rows..

[stacydrennan]

@Firchild - Hmmm, it's very possible I did something wrong, but when I tried it in its default location (col 4 I think), it always defaulted to the very last record. Every field had the value of the final entry. Once I moved it to Column A, it suddenly filled everything out correctly.

[Firchild]

@stacydrennan I'll look into it

[shhanouq]

Your Excel v lookups are awesome mate! cheers...

[Janehop41]

Your Excel vlookup videos are really helpful. I'm trying to get a budgeting s/sheet sorted and this will make everything so much better. Thanks.

[thering25]

Very good one:-) Quick question, I have spreadsheet with houndreds of columns how do I get column number?

[gredangeo]

@thering25 One way is a logical formula. Just take the column letters and muliply. ex: CF is 3x26 + 6 = 84. (C is third letter, F is the sixth letter). Now, if you're highlighted area does not start with column A, just subtract the difference that you've moved over. If you're for some reason using 3 letter columns, the math is (for AAA) 1x676 + 1x26 + 1 = 703

Hope that helps

[blksun98]

Thanks alot this was a great help to visualize using this formula. Saved me a ton of manual lookup work.

[imkhay]

thank ui so much

[juzoom]

short and right to the point - thanks a lot!

[mikolotsky]

ahaha. i was having a lot of problems trying to figure out what i'm not doing right. hahaha. thanks! haysss.

[midoelsaady]

tthanks

[MizzprEEETy]

THANKS!

[akmalkh]

:) Not Bad