Solved: populate a two column search result

[gringo287]

Hi,

I have the formula, which works really well as a search "engine".

My query, is how to adapt the formula to allow me to populate a two column result, as my search is based on one column of titles for urls and the other is the actual url, so i need both to be populated.

test file attached

[snb]

in cell D10:




=IFERROR(INDEX($L$15:$L$45;MATCH(SMALL(IFERROR(SEARCH($C$7;$K$15:$K$45)+ROW ($K$15:$K$45)/1000;"");ROWS($C$10:C10));IFERROR(SEARCH($C$7;$K$15:$K$45)+ROW($K$15:$K$45)/1000;"");0));"")

[gringo287]

Thank you snb, thats looks annoyingly simple, as it seems it was as easy as just changing the column over to L, but i cant get it to work?, just tells me it contains an error

[gringo287]

sussed it. good old vlookup. Im sure i would have been doing something wrong with you formula snb, but i couldnt figure it so checked vlookup, not expecting it to work, but its fine. thanks anyway, for your time

[snb]

You proably didn't replace the semicolon by a comma.