Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup problems
Hi
Id appreciate any advice on this lookup issue please. Basically I have 2 worksheets in a workbook. Both have the same data in column D, and I would like to set a lookup in Sheet 1, to look into Sheet 2 and where column D data matches in each sheet return the Value from Sheet 2 column H into a new cell in Sheet 1. Does this make sense? Im sure it should be a simple task, but so far Ive not had any luck. Thanks in advance. |
#2
|
|||
|
|||
You only need to post your question in one place. :)
************ Anne Troy www.OfficeArticles.com "JaB" wrote in message ... Hi Id appreciate any advice on this lookup issue please. Basically I have 2 worksheets in a workbook. Both have the same data in column D, and I would like to set a lookup in Sheet 1, to look into Sheet 2 and where column D data matches in each sheet return the Value from Sheet 2 column H into a new cell in Sheet 1. Does this make sense? Im sure it should be a simple task, but so far Ive not had any luck. Thanks in advance. |
#3
|
|||
|
|||
=IF(ISNA(VLOOKUP(D2,Sheet2!$D$2:$H$20,5,False)),"" ,VLOOKUP(D2,Sheet2!$D$2:$H
$20,5,False)) and copy down -- HTH Bob Phillips "JaB" wrote in message ... Hi Id appreciate any advice on this lookup issue please. Basically I have 2 worksheets in a workbook. Both have the same data in column D, and I would like to set a lookup in Sheet 1, to look into Sheet 2 and where column D data matches in each sheet return the Value from Sheet 2 column H into a new cell in Sheet 1. Does this make sense? Im sure it should be a simple task, but so far Ive not had any luck. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function Problems | Excel Worksheet Functions | |||
simultaneous entry lookup problems | Excel Worksheet Functions | |||
How to overcome LOOKUP function problems? | Excel Worksheet Functions | |||
lookup problems | New Users to Excel | |||
Lookup problems | Excel Worksheet Functions |