Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling data from one sheet to another
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling data from one sheet to another
=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. "Jeremy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pulling state data from another sheet | Excel Discussion (Misc queries) | |||
Pulling Data from another sheet | Excel Discussion (Misc queries) | |||
pulling data from one sheet to another | New Users to Excel | |||
pulling data from another sheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |