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
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
ASKER
sure, if the column has to be moved over no problem
ASKER
can you fill the vlookup info into the first row for me to get me going, thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Note that if using Excel 2007 or later you can use IFERROR to shorten those formulas, e.g.
=IFERROR(INDEX(DATA!A:A,MA TCH($C2,DA TA!B:B,0)) ,"Unknown" )
regards, barry
=IFERROR(INDEX(DATA!A:A,MA
regards, barry
ASKER
wonderful
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.