Excel help please (vlookup I think)

Pretty much hit the nail on the head.

Based on the other screenshots above, I should expect to see the returned results from sheet 1, row 2, to appear as:

capturezf.png
 
You need to be searching for a unique Part identifier, not the column headings. For example, in Sheet1 A2 if you have Part1, then you'd need something like:

VLOOKUP("PART1",Sheet1!A1:CV1000,2,false)

"Part1" needs to be the cell reference where you're choosing Part1 from your list of unique Parts. Is the Column Package Name your unique list?

If so, for the Cell D14 for Factory Packaging you'd need:

VLOOKUP(Sheet2!B14,Sheet1!A1:A100,2,FALSE). What this does is lookup "Part1" in Sheet2 ColumnA, then goes across to the second row and retrieves the Factory Packaging value for that particular Part.

However, the syntax for what you're looking for and the unique Part name in the database needs to be identical. So you might need to not use a cell reference for B14 and just use the actual header name ... in quotes I think.
 
Last edited:
ok, I think. But Sheet1, B14 is a blank cell. Do I have to do these list ranges more than once or something?

It seems to me that you think I'm going to know all the values that will appear in the DB and list them out. But I don't. Anything could get chucked in there, be completely random and my cells need to reflect what they see from the database rows.

Ohhhhh, baby jesus is even getting sad now :(
 
Last edited:
Lucero said:
It seems to me that you think I'm going to know all the values that will appear in the DB and list them out. But I don't. Anything could get chucked in there, be completely random and my cells need to reflect what they see from the database rows.

Ohhhhh, baby jesus is even getting sad now :(
Click to expand...

Whatever gets chucked in the DB must have a unique part number though? Or could there be a repeat of the same part number with different values in the other columns?
 
what column are you classing as 'part number'? A? (sheet1).

You are right though, everything will be unique (or should be). I just can't seem to figure this out and its making me angry!!! :)
 
Any way you could email the sheet mate, at work so can't see the screenies? Would be easier for me to try and help.

I will email my addy to your trust.
 
Malakite said:
Any way you could email the sheet mate, at work so can't see the screenies? Would be easier for me to try and help.

I will email my addy to your trust.
Click to expand...

This would be easier lol. Make sure you fill in a few rows of dummy data so that you'll be able to follow a working example.
 
The macro recorder is untidy and requires editing. It's great for a rough idea, but a polished product it is not. Also, since his raw data (exported from DB) is dynamic he'd need to use relative references and an rngFound/ifNothing to make sure things are going to the right place.

For the sake of simplicity, Luceros best bet is the vLookup. Whilst VBA would be a decent long term solution, it's not really necessary given his Excel experience.
 
hmm not received anything, might be work secuity blocking the attachment. If you want send it to the hotmail address in my trust and I will have a look when i get home.
 
Hey mate

I was bored so put a sheet together that I think will do what you want.
It is using a combo box for you to select what row in the database table you want. this then links to the vlookups in each of the question boxes to fill in the data.

I sent you an email so i can get your addy and see if its what your after.
 
Hey got the sheet and no problem to get working, it's mostly the same as what I knocked up for you last night, just a quick question.

First what is your identifier for what row in your data table you want populated in the other sheets. Are you just wanting to pisk a row number or package name etc. So you will have a list, pick one and that will populate your sheets. What should be in the list?
 
If I understand you correctly, I just want the user to highlight row 2, 3, 4, whatever, and it it makes the cells in the other worksheets change value based on the row picked.

Is that possible?
 
You must log in or register to reply here.
Back
Top Bottom