Can you explain a little, I am trying to adjust your formula to match my spreadsheet and I can not get it to work......???
Can you explain a little, I am trying to adjust your formula to match my spreadsheet and I can not get it to work......???
Post your workbook with an explanation of what you want, and I will modify the workbook and re-post it.
Hi
Attached is an example of what I am looking for.
Thanks again for the help!
Try this array formula** entered in cell D6 on the Working Sheet:
=IFERROR(INDEX('Contractor list'!$B:$B,SMALL(IF('Contractor list'!$A$2:$A$17=$B4,ROW('Contractor list'!$A$2:$A$17)),COLUMNS($D6:D6))),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Copy across until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
The formula works! Brilliant! Thank you very much Tony... life saver
BL
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.
Thanks again Tony!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks