أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
VLookup searches down the leftmost column of a table for a match and returns a value from a column to the right of the match on the same row.
http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm HLookup searches left to right across a row of entries for a match and returns a value from a row below the column the match was found in.
http://spreadsheets.about.com/od/excelslookupfunctions/ss/-excel-2007-hlookup-tutorial-sbs.htm