Excel Pros
Thread Starter
I got worms.
Joined: Jul 2000
Posts: 32,238
Likes: 0
From: Utah
Excel Pros
Tell me if this is possible.
If A1 equal any of the values in column A from another worksheet, copy the value from the row D of the matched record into D1. Else write '-'.
If A1 equal any of the values in column A from another worksheet, copy the value from the row D of the matched record into D1. Else write '-'.
__________________
99 Integra GSR
06 TSX
duck squad member #00003
99 Integra GSR
06 TSX
duck squad member #00003
h:.
BOOM goes the dynamite!
Joined: Mar 2003
Posts: 27,571
Likes: 1
From: in a van down by the rive
.......
Joined: Jun 2002
Posts: 522,629
Likes: 0
From: noobtown
=IF(A1=Sheet2!$A$1:$A$9,Sheet2!D1,"-") -
the $ is to hold your range so when you cut and paste it doesnt move, but this will probably not work too well if you have different information in D but the same in A
the $ is to hold your range so when you cut and paste it doesnt move, but this will probably not work too well if you have different information in D but the same in A
__________________
94 Chevy Blazer - brother crashed.
94 2dr accord - h22 swap, rear ended.
03 1.8 gti - waiting for her bag of chips.
:crazyr: :slap: :hsughr: :nec: :madr:
94 Chevy Blazer - brother crashed.
94 2dr accord - h22 swap, rear ended.
03 1.8 gti - waiting for her bag of chips.
:crazyr: :slap: :hsughr: :nec: :madr:
Last edited by Nec; Jul 16, 2008 at 01:37 PM.