Vlookup

Posted by Sam Cutruzzula on February 08, 2001 9:49 PM

Friends pls make it easy for me. I have 2 worksheets. I want to pull the data that corresponds with a name from sheet 1 and copy it to worksheet two. Please provide the formula for the example below.

Worksheet1 Worksheet 2
Column A Column B Column A Column B
Sam 100 Sam formula
Gail 200 Gail formula

Thanks Sam

Posted by Dave Hawley on February 08, 2001 10:13 PM

Hi Sam

This formula will look in the left most column of A1:F500 of Sheet1 for the value in cell A1 of Sheet2 and return the value from the same row but 2 columns over.

=VLOOKUP(A1,Sheet1!$A$1:$F$500,2,FALSE)

Hope this helps

Dave
OzGrid Business Applications