Pulling data from one sheet to another

J

Jeremy

In excel I have two sheets that I am using and want certain data to be pulled
from Sheet 1 to sheet two when a certain criteria is met. The criteria is in
colum A of sheet 1. Below is an example of what I need.

Thanks

Sheet 1

A B C

1 01/64 48.95 15
2 02/48 46.29 28


Sheet Two
A B C D

1 01/64 42 48.95 15
2
3
4 02/48 15 46.29 28
 
S

Sean Timmons

=VLOOKUP(A1,sheet2!A:D,3) will return 48.95 in row 1

=VLOOKUP(A1,sheet2!A:D,4) will return 15 in row 1.

In the above case, if no exact match in A, then the next closes value is
selected. To nly match exact, add ,0 to the end of both vlookups.
 
Top