Excelを動画で学ぼう! - VLOOKUP in Excel 2007
Search:

基本 操作 セル 関数 計算 数式 マクロ 並べ替え シート ブック 更新 保存 挿入 レイアウト データ 校閲 アドイン

VLOOKUP in Excel 2007

EXCEL𓮉ŊwڂI
EXCEL𓮉ŊwڂI EXCEL𓮉ŊwڂI
EXCEL𓮉ŊwڂI

Several examples of using the VLOOKUP function in Excel 2007

Channel: Howto & Style
Uploaded: November 30, 1999 at 12:00 am
Author: rrphillips

Length: 09:49
Rating: 4.81
Views: 158010

Tags: 131  2007  235  cis  cocc  excel  function  phillips  ralph  rrphillips  vlookup  

Video Url:


Embed Code:

Video Comments

wexler211 (November 30, 1999 at 12:00 am)
I found your explanation to be very clear! Excellent examples as well. In the classroom, if you were reinforcing other skills, you could also have copied the rank array and pasted it, instead of retyping it, and then use sort, remembering to expand the selection. Thanks for the great demo!
pujyamvk (November 30, 1999 at 12:00 am)
very useful for me thanks
nz2k2 (November 30, 1999 at 12:00 am)
Thanks very much - my head was starting to ache trying to follow the Openoffice example, but this had me sorted in a moment. Working through your other vids now!
lilushlb (November 30, 1999 at 12:00 am)
awasome. thank you so much. this is sucj a great video, very helpful... I am starting to like this program, which i use to dislike. it's not so difficult after YOU explain. great tutorial
tanctanc (November 30, 1999 at 12:00 am)
Thank you. Very nice.
HOLLIEHOILEI (November 30, 1999 at 12:00 am)
Thankyou so much! You just explain it so clearly! Good vid!
BUTTERFLYWARIOR (November 30, 1999 at 12:00 am)
A clear and informative video. This function is now meaningful, I appreciate how it can be used. Thanks very much for taking the time to make the video it has helped me alot. Cheers Ralph!!
rrphillips (November 30, 1999 at 12:00 am)
I think when I recorded this video I left the randbetween function on while working so that the scores were frequently changing.
Vhiij (November 30, 1999 at 12:00 am)
so, a student had 100% and after the formula it went down to 99%. Guess you did something funk there. Works fine here, although I ctrl dragged down on B3 to B8 - yes I used less students in mine and it didn't change the percent as opposed to yours.
KapriciousMind (November 30, 1999 at 12:00 am)
Thank You so much! it was so very helpful.... i always thought vlookup was a very complicated formula and was avoiding it.... with your example and explanation... i just got to know its so simple!!! Thanks again.

Excelを動画で学ぼう! © 2007 All Rights Reserved.