Rubin Shrestha
Zend certified PHP/Magento developer
Rubin Shrestha
Blog

Excel, Apple. How do auto fill one cell with corresponding info based on entry of another cell

by |Published

I have three Sheets. Sheet 1(Model Number), Sheet 2(Item Number) and Sheet 3(Reference). I want to be able to put a model number of an item in to a certain cell(J17)on sheet 1 and have it auto fill the corresponding item number in to a cell (B2) on sheet2. I have the reference sheet set up with cell D3 as the item number and cell E3 as the item number.
I have used the following formula, =VLOOKUP(‘Phase 1’!J17, Reference!D3:E42, 2). This is giving me an item but not the correct item number. Is there anyway to explain to me what I am doing wrong?

You may also like