Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel


  • Please log in to reply

#1
Possible

Possible

    Member

  • Member
  • PipPip
  • 62 posts
Hey,

I was wondering is this is possible in Excel 2000

I currently have a spreadsheet that pulls data from one sheet to the next. For example, one sheet has all data, the other one, when I type a sku in the information appears that was put in the data sheet.
What I want to do, is put a whole bunch of addresses in the data sheet, so that on the master sheet, when I type a sku in, the rest of the address shows up.

Can this be done?

Thanks,
Possible
  • 0

Advertisements


#2
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
Hi Possible,
You can use a VLOOKUP function

=VLOOKUP(B2,Sheet2!$A$1:$B$4,2,FALSE)

Sheet1 - Cell C2 is where the above formula is located
Sheet1 - Cell B2 is where you have typed your sku
Sheet2!$A$1:$B$4 is the range containing your SKU number and associated data
2 is the column number in the above range of the data to return
False is required to ensure exact match


Regards
David
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP