Need help with macro for 2 worksheets
Closed
mjaybee
Posts
5
Registration date
Wednesday January 16, 2013
Status
Member
Last seen
January 17, 2013
-
Jan 16, 2013 at 09:28 AM
mjaybee Posts 5 Registration date Wednesday January 16, 2013 Status Member Last seen January 17, 2013 - Jan 17, 2013 at 12:24 PM
mjaybee Posts 5 Registration date Wednesday January 16, 2013 Status Member Last seen January 17, 2013 - Jan 17, 2013 at 12:24 PM
Related:
- Need help with macro for 2 worksheets
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Need for speed underground 2 download apk - Download - Racing
- Need for speed most wanted 2 download apk - Download - Racing
2 responses
mjaybee
Posts
5
Registration date
Wednesday January 16, 2013
Status
Member
Last seen
January 17, 2013
Jan 16, 2013 at 01:10 PM
Jan 16, 2013 at 01:10 PM
I'm trying to make the VLOOKUP work, because that seems simpler, but it keeps returning #NA even though there is a match. Here's the formula I'm using
=VLOOKUP(A4,OLD!$A1:$A1404,2,FALSE)
I thought this was taking the value of the cell A4 on the current sheet and looking in the sheet called OLD in colum A rows 1-1404, and returning what is in column 2 of OLD when there is an exact match.
In this case I have the number 9 in A4 of my current sheet and in row A7 of the sheet called OLD. I want the X from OLD, column 2 of row A7 to be copied to column 2 of the new sheet. I know there is a match, but it has #NA as the result.
What am I missing?
=VLOOKUP(A4,OLD!$A1:$A1404,2,FALSE)
I thought this was taking the value of the cell A4 on the current sheet and looking in the sheet called OLD in colum A rows 1-1404, and returning what is in column 2 of OLD when there is an exact match.
In this case I have the number 9 in A4 of my current sheet and in row A7 of the sheet called OLD. I want the X from OLD, column 2 of row A7 to be copied to column 2 of the new sheet. I know there is a match, but it has #NA as the result.
What am I missing?
mjaybee
Posts
5
Registration date
Wednesday January 16, 2013
Status
Member
Last seen
January 17, 2013
Jan 17, 2013 at 12:24 PM
Jan 17, 2013 at 12:24 PM
Solved this with my vlookup formula