I have one other question
I didn't add in the worksheet that I wanted the formula to skip columns so instead of the having the formula work in the column to the immediate right I need it to work 8 columns over? Would you be able to modify the formula to accomodate?
(After going back I realized I missed this impt criteria)... Thanks again...
If I understand, you just need to modify this bit of the formula:
INDEX('Contractor list'!$B:$B
Change it to whatever column you want the results to come from.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks again Tony!
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks