Update a cell based on another lookup

[chimp]

I am tring to get a cell, in this case G4 to update automatically, based on the entry that i type in G2

what i want it to do is lookup the daycode that i type in g2, against the daycodes listed in column A the in G4 display the cases produced.

any help please

Book1
	A	B	C	D	E	F	G
1	Daycode	Cases					Lookup
2	5000	1000					5015
3	5001	1001					Result
4	5002	1002					1015
5	5003	1003
6	5004	1004
7	5005	1005
8	5006	1006
9	5007	1007
10	5008	1008
11	5009	1009
12	5010	1010
13	5011	1011
14	5012	1012
15	5013	1013
16	5014	1014
17	5015	1015
18	5016	1016
19	5017	1017
20	5018	1018
21	5019	1019
22	5020	1020
23	5021	1021
24	5022	1022
25	5023	1023
26	5024	1024
27	5025	1025
28	5026	1026
Sheet1

 

[fairwinds]

Hi,

Try:

=VLOOKUP(G2,A2:B28,2,0)

in G4