Hey,
So i have attached a sheet to this. Basically i have 3 columns and i know how to VLOOKUP for one piece of data but i have quite a few that i would like it to automatically group. The sheet will explain it better.help2.xlsx
Hey,
So i have attached a sheet to this. Basically i have 3 columns and i know how to VLOOKUP for one piece of data but i have quite a few that i would like it to automatically group. The sheet will explain it better.help2.xlsx
Hi
You need to be more specific about what you are trying to achieve as your spreadsheet does not give this.
Please explain what you are trying to lookup and when found exactly what cells you want to Average. This will help us provide a potential solution.
Tony
Are you using XL2003 as indicated?
Hi,
This array formula (enter with CTRL+SHIFT+ENTER, not just ENTER) in cell L4 of your sheet and copied down:
=AVERAGE(IF(ISNUMBER(SEARCH(LEFT($K4,1)&"?"&RIGHT($K4)&"?",$B$2:$B$28)),$C$2:$C$28))
This array formula in cell M4 of your sheet and copied down:
=AVERAGE(IF(ISNUMBER(SEARCH(LEFT($K4,1)&"?"&RIGHT($K4)&"?",$B$2:$B$28)),$D$2:$D$28))
Will work for single-digit numbers to the left and right of your "-", so let me know if these will go above single digits.
Regards
A little shorter perhapsentered as an arry formula with Ctrl+Shift+EnterPlease Login or Register to view this content.
Perfect, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks