vlookup help

  • Thread starter Thread starter ngoctrang2000
  • Start date Start date
N

ngoctrang2000

Hi everyone

here is an example of what the massive data looks like

A (sheet 1) B(sheet 1) A(sheet 2) B(sheet 2)
store states store states
1 - 4
MN
2 - 3
TX
3 - 1
CA
4 - 2
SD
5 - 6
MI
6 - 5
AL

What I want to do is to match the store# from column A (sheet 1) with
store# from column A(sheet 2) and then insert the corresponding states
into column B (sheet 1). The data is so massive that it is impossible
to get it done this week. Could someone help with this? I'll greatly
appreciated.

NT
 
NT,

=VLOOKUP(A2,Sheet2!$A$2:$B$10,2,FALSE)

Copy down with the Fill Handle
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
NT,

=VLOOKUP(A2,Sheet2!$A$2:$B$10,2,FALSE)

Copy down with the Fill Handle
--
Earl Kiosterudwww.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...









- Show quoted text -
Click to expand...

Hi Earl,

I finally learn how to do it, thanks so much
 
Back
Top