Thread: Excel Pros
View Single Post
Old Jul 16, 2008 | 01:44 PM
  #16  
94civicEX's Avatar
94civicEX
I got worms.
 
Joined: Jul 2000
Posts: 32,238
Likes: 0
From: Utah
Default

=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.

Originally Posted by 94civicEX
=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?
__________________
99 Integra GSR
06 TSX

duck squad member #00003
Reply