Excel Pros
CBOTY 2010
Joined: Nov 2004
Posts: 34,786
Likes: 0
From: MI
BOOM goes the dynamite!
Joined: Mar 2003
Posts: 27,571
Likes: 1
From: in a van down by the rive
he needs it if A1 (sheet 1) matches anything in A (sheet 2)
Thread Starter
I got worms.
Joined: Jul 2000
Posts: 32,238
Likes: 0
From: Utah
=LOOKUP(A12,Sheet2!A:A,Sheet2!I:I) FTW
Thank you guys. I'm a noob when it comes to that stuff in Excel, lol.
Actually that is working when the condition exists, how do I have it put - if there is no match?
Thank you guys. I'm a noob when it comes to that stuff in Excel, lol.
Actually that is working when the condition exists, how do I have it put - if there is no match?
__________________
99 Integra GSR
06 TSX
duck squad member #00003
99 Integra GSR
06 TSX
duck squad member #00003
.......
Joined: Jun 2002
Posts: 522,629
Likes: 0
From: noobtown
=IF(A1=Sheet2!$A$1:$A$9,Sheet2!D1,"-")
__________________
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:
.......
Joined: Jun 2002
Posts: 522,629
Likes: 0
From: noobtown
"-"
__________________
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:
Thread Starter
I got worms.
Joined: Jul 2000
Posts: 32,238
Likes: 0
From: Utah
Code:
=IF(ISNA(VLOOKUP(A:A,Sheet2!A:I,9,FALSE)),"-",(VLOOKUP(A:A,Sheet2!A:I,9,FALSE)))
h:
__________________
99 Integra GSR
06 TSX
duck squad member #00003
99 Integra GSR
06 TSX
duck squad member #00003