Look Up Confusion

trainer75

New Member
Joined
Jun 11, 2015
Messages
30
Hi I am trying to put together a temporary picking form and are currently having some issues and hope someone can help.

I have currently 3 tabs
Tab 1 is the main tab that will be my temporary pick sheet
Tab 2 and 3 is where I will have data but this will be all together.
I need to identify what stock is for which area, the area's are in rows, then the stock info is in columns.
So on Tab 1 I have a drop down list that would choose Tab 2 or Tab 3 then another drop down list that would choose the area.

My end goal is to select the drop down box for tab 2 or 3, then select the area from the other drop down box, this would then auto populate the fields that I am looking for.

Hope someone can assist
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

emmarahudson

New Member
Joined
Mar 19, 2014
Messages
23
Hi

If you email me some sample data and a bit more info (emma_ra_Hudson@yahoo.co.uk), I'll have a look and see if I can help. I'm just not quite clear what you need and it might be easier for me to see it.

Em
 

trainer75

New Member
Joined
Jun 11, 2015
Messages
30
Hi

If you email me some sample data and a bit more info (emma_ra_Hudson@yahoo.co.uk), I'll have a look and see if I can help. I'm just not quite clear what you need and it might be easier for me to see it.

Em
Hi Emma,

Thank you for your assistance, my goal posts have now been changed, so no longer looking at that part, thank you anyway.
Don't know if you could assist me with another problem that's arisen?
In column D I have a list of media (ie CAGE, PALLET, TOTE etc) and in column E I have a cumber which references what row they are in on another tab, I then pick which media by a drop down box and then I want the number to show in reference to the row.
The formula I have is
=LOOKUP(A7,D1:D7,E1:E7)
Unfortunately the numbers don't match the media and I cant fathom out why

Hope you can help :)
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
43,650
Office Version
365
Platform
Windows
If you email me some sample data ..
That is not allowed. Please refer to #4 of the Forum Rules

You might also want to consider the wisdom of openly publishing your email address in a public forum where spamming robots regularly trawl for email addresses.
 

Teeroy

Well-known Member
Joined
Nov 9, 2012
Messages
2,240
Hi Peter, now that you've sacred @emmarahudson with a healthy dose of common sense (that seems less and less common :)) how about removing her email address as only a mod can change a user's post past 10 minutes or so.
 

trainer75

New Member
Joined
Jun 11, 2015
Messages
30
That is not allowed. Please refer to #4 of the Forum Rules

You might also want to consider the wisdom of openly publishing your email address in a public forum where spamming robots regularly trawl for email addresses.
Hi there,
no worries I wouldn't send to an email address purely for that reason.
stick to the forum :)
 

Watch MrExcel Video

Forum statistics

Threads
1,090,055
Messages
5,412,083
Members
403,411
Latest member
aspofford

This Week's Hot Topics

Top