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.
 

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

Top