Need help transfering data from one sheet to another to update missing information
Hello!
I'm a newbie and I need help trying to update missing information on a worksheet. I'm trying to learn how to use formulas to pull information from one sheet to another. On sheet "A" I have a sheet containing various incident numbers. Each incident has fields that are missing data. On Sheet "B" I have the identical sheet except the fields have been updated. I want to transfer this information and match it to the matching incident numbers. Please help!!
You can use a vlookup formula in SheetA which will pull the values from SheetB whenever they are entered in B.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Re: Need help transfering data from one sheet to another to update missing information
Thank you. Unfortunately, I have never used a vlookup formula before. Can I get a step by step guide to pull data from one sheet to another?
Put this formula in E4 of SheetA =IFERROR(VLOOKUP($C4,'Sheet B'!$C:$Y,3,0),"")
Similarly, put this formula in G4 =IFERROR(VLOOKUP($C4,'Sheet B'!$C:$Y,5,0),"")
Repeat for the other columns. Drag down as required.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks