Link to home
Start Free TrialLog in
Avatar of zyanj
zyanj

asked on

Auto Fill Spreadsheet with Vlookup

I have attached a sample spreadsheet. I would like the highlighted cells to be filled in with the data from the "DATA" tab.

Everything is in reference to the material number. So if the "Material Number: has data in the cell on sheet 1 I want it to compare it to the data table and fill in all of the corresponding cells

I forgot how to do this. =IF(ISNA(VLOOKUP(... ?????
test-table.xlsx
Avatar of sentner
sentner
Flag of United States of America image

It's a little tricky since you have the Item column before the Material column in the data table.  Can you switch those 2 there?  

If not, you have to find the row, and then pull the item number by reference.  But it's a straight vlookup if you can move the material column in the data table to the beginning.
Avatar of zyanj
zyanj

ASKER

sure, if the column has to be moved over no problem
Avatar of zyanj

ASKER

can you fill the vlookup info into the first row for me to get me going, thanks
ASKER CERTIFIED SOLUTION
Avatar of sentner
sentner
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of barry houdini
Note that if using Excel 2007 or later you can use IFERROR to shorten those formulas, e.g.

=IFERROR(INDEX(DATA!A:A,MATCH($C2,DATA!B:B,0)),"Unknown")

regards, barry
Avatar of zyanj

ASKER

wonderful