Jump to content

vlookup and hlookup in excel


vpatterson

Recommended Posts

I am fairly new to excel and I am trying to take information from one excel file and have it automatically load information in another. I know it is possible with a formula but how do I use it? please help

Link to comment
Share on other sites

Do you want the information to be read or written? where is the information to start with and where should it go, will the workbooks be open? It's late here, but if you can give an example it would help a lot in explaining possible ways of doing it

Link to comment
Share on other sites

First off VLOOKUP can only be used if you're look up value is in the left most column (top most row for HLOOKUP) so there are limitations.

 

First off you need the look up value, second is your look up array, this is the entire set of data you are looking up the information in.

 

Last is you column number inside the array you just specified (3 is the 3rd column in the array, so the SKU number in the attached example). The HLOOKUP is identical with the rows and column being reversed.

 

Note that by adding FALSE at the end the first column (where you're look up value is) does not have to be sorted alphanumerically.

Computer.xlsx

Link to comment
Share on other sites

I had some help from here at work and this is what we came up with and it works.

My second excel spreadsheet now automatically up dates after I fill in my Master List, so no more copying and pasting!

Thanks for yalls feedback!

Here is the formula I used just incase anyone else runs into the same problem.

=IF(VLOOKUP($A256,'HGD MASTER LIST 101306 my copy.xls'!MasterList,2,FALSE)="","",VLOOKUP($A256,'HGD MASTER LIST 101306 my copy.xls'!MasterList,2,FALSE))

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...