How to write formula for Column hurdle query

**metrostar** · 08-30-2020, 10:10 AM

I2 cell name
I3 cell Let user input name
J3 Write a formula to find out the result

The name is in the B, D, F column
The CODE to be queried is in column C, E, G

**Bo_Ry** · 08-30-2020, 10:17 AM

Please try

=CONCAT(INDEX(REPT(C3:G7,B3:F7=I3),))

**metrostar** · 08-30-2020, 10:41 AM

Great, thank you for helping me solve the problem

How to write formula for Column hurdle query

LinkBack

Thread Tools

Rate This Thread

Display

How to write formula for Column hurdle query

Re: How to write formula for Column hurdle query

Re: How to write formula for Column hurdle query

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] SQL - query on excel cells rather than write the query text?

how do I write this formula? If column B contains column A value, return value in column C

[SOLVED] Cannot write a formula in Excel 2010 to answer query and give a final COUNTIF number

Progress chart with a average hurdle bar ( Attachment)

Progress chart with a average hurdle bar

How to write Query in Excel (MS Query)

[SOLVED] Split Profits to different partners based on hurdle rates

Bookmarks

Bookmarks

Posting Permissions