Account Options>

  1. Sign in
VLookup
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
|
 
Still loading...
ABCDEF
1
Q1
2
Data 1Data 2Result
3
001567APPLE
4
001758ORANGE
5
001123
WATERMELON
6
002654PEAR
7
002123MELON
8
002758CARROT
9
003123AVOCADO
10
11
Question:
12
How I can get the "MELON" result when I type "002123"?
13
14
15
16
17
Q2
18
NameScore
19
Angelina80
20
Brian85
21
Catherine90
22
Diana95
23
Enrique88
24
25
26
Show the Score based on Name
27
NameAngelina
28
Score80
29
30
Question
31
How I can show the name of student based on the score?
32
33
Show the name based on Score
34
Score88
35
Name
Loading...
 
 
 
Q1
Q2
Sheet3