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 - Form Problem


  • Please log in to reply

#1
jringo

jringo

    New Member

  • Member
  • Pip
  • 4 posts
I made a form in Excel.

I have 2 lists in sheet 2, one called UNIT, the other Account.

The UNIT and their Account are on the same row.

On the form I made a drop down field to enter the Unit. It works.

I would like to have the Account for the Unit filled in the Account field on the form when the Unit is selected from the drop down menu.

How do I do this?

Please email me your answers.

imirradiated @gmail.com
  • 0

Advertisements


#2
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
what version of excell (it does matter)
  • 0

#3
jringo

jringo

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts
2002
  • 0

#4
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
ok I think I know want you want eg
you pick from a drop down list a unit lets say HP then the next column shows
House paint.
or you pick from the drop down list CP and the next column shows car paint
Am I on the right track?
  • 0

#5
jringo

jringo

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts
Yeah, that's correct. The UNIT and Account are in 2 different list on SHEET 2.

UNIT Col "A", Account Col "C"

Their are 380 Units ( Rows ) with its Account number on the same row but in Col "C"

The drop down box is cell B5.

I want the Account number for the selected unit to appear in cell B6.
  • 0

#6
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
I will send you a small sample of an excell file
just to make sure I have want you want
  • 0

#7
jringo

jringo

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts
I found out how at www.mrexcel.com.

=INDEX(Sheet2!A1:C380,MATCH(B5,UNIT),3)

This works but if nothing has been entered in B5, it displays "#N/A" in B6.

Anyone have the fix?

Thanks

Edited by jringo, 02 June 2005 - 08:40 PM.

  • 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