|
|
 |
| Excel VBA Discuss using VBA for Excel programming. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Excel VBA section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
October 19th, 2009, 01:22 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2006
Location: Ennis, Clare, Ireland.
Posts: 122
Thanks: 6
Thanked 0 Times in 0 Posts
|
|
Cell formula query
Hi,
I need to build a formula in a column I on Account_Setup worksheet within my workbook.
Firstly, it is based on whether Column H on the same sheet is <> blank "" (if Column H = blank then Column I = 1)
Secondly, if the value of column H is NOT blank, it will match a value found within a table held on a separate sheet (Setup_Tables H5:H54). The formula should return the value held in the adjacent column I from the Setup_Table worksheet).
I think its something like:
Code:
=IF(H7<>"",INDEX(Setup_Tables!H5:H54,MATCH(H7,Setup_Tables!I5:I54,0)),1)
but I'm getting an '#N/A' error.
Any ideas? Hope this makes sense,
Thanks in advance,
__________________
Neal
A Northern Soul
Last edited by Neal : October 19th, 2009 at 01:48 PM.
|
October 19th, 2009, 01:53 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2006
Location: Ennis, Clare, Ireland.
Posts: 122
Thanks: 6
Thanked 0 Times in 0 Posts
|
|
I think I've found the answer. It should perhaps be:
Code:
=IF(H7<>"",INDEX(Setup_Tables!I5:I54,MATCH(H7,Setup_Tables!H5:H54,0)),1)
Thanks anyway.
__________________
Neal
A Northern Soul
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
