VLOOKUP Macbook Excel 2016

preview_player
Показать описание
This video is to demonstrate how to use a vlookup function using both relative and absolute referencing.
Рекомендации по теме
Комментарии
Автор

HOW I CAN IN GET PLAYERS (SUM OF POINT PER GAME) DATA IN HIGHLIGHTED ROW, WHEN I AM HAVING DUPLICATE NAMES IN PLAYERS LIST.

parulchauhan
Автор

so i have an excel sheet with many employee numbers and first and last
name of employee in one sheet on a second sheet i have only couple
selected employees. How can i filter my main database to only those few
workers on the second sheet. I have pasted an example.



sheet 1 with all users information.

Employee #
FIRST_NAME
LAST_NAME

102698
Nancy
Becton

103671
Robert
Brackins

107697
Jack
Eknath

111561
Ruth
Jackson-hill

113623
Sandra
La Farge

116303
Janet
Lemus

116730
Suryaprabha
Medina

116860
Ruby
Newton

117026
Paula
Smoot

117187
Sandra
Stewart

117243
Lisa
Yoder

117414
Patsy
Zantiny






On sheet 2

Employee #
FIRST_NAME
LAST_NAME

103671
Robert
Brackins

113623
Sandra
La Farge

116860
Ruby
Newton

117243
Lisa
Yoder






On sheet 1 I want to look up only those people on sheet 2. how can i filter this, please help

ramonsantos