MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF commands i think

Posted by neil white on February 05, 2002 3:16 PM

I have a spread sheet which has two sheets
I want it so if i type a value into cell ( ie 345 in cell b3)
then it will look up the value (345) in the other sheet and input the linked values into the first sheet

so if sheet 1 has a value (345) in B3 it will look up 345 on the other sheet( cell d3) and input the values of E3 and F3 into cells d3 and d4 into the sheet
i have approx 700 lines of data

Posted by Derek on February 06, 2002 5:45 AM

Re: You can use the Vlookup formula if your lookup values are consecutive