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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pulling from one sheet to another 3
one of two criteria 11
Matching call data based on date, time and number called to give c 1
LOOKUP function between two dates in Excel 2007 6
LOOKUP within a 1
vlookup or Match 6
pulling data 3
Pulling an column/row Data from one sheet- another if critria is m 1

Top