Page 124 - الحاسب الآلي ثانية إرشاد 2

Excel ‫اﻟﺪوال ﻓﻰ ﺑﺮﻧﺎﻣﺞ‬ ‫اﻟﻔﺼﻞ اﻟﺴﺎﺑﻊ‬

.
‫ﻤﺜﺎل‬

nada Ahme
d

43
72
1 45
3 10

=HLOOKUP("nada",A1: B5,2)
4
=HLOOKUP("ahmed",A1:B5,3)
2
=HLOOKUP(3,A٢:B5,3)
45
=HLOOKUP(45,A4:B5,2)
10

=HLOOKUP(3,{1,2,3,"ahmed","nada","sama","krem","yara","kha

led"},2)

sama

VLOOKUP -٢

Ahmed Nada . HLOOKUP

١٢٤