The problem is I need to search a range (most of a row), not a cell. That's what's tripping me up. I guess I could concatenate those cells first--it's just dragging the formulas, in the end.
Thanks.
Riley: No pulse. Anya: Yup. The space lamb got 'im.
'Never Leave Me'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
§ ita § - Jul 21, 2010 4:31:22 pm PDT #14496 of 25501
Well not canonically, no, but this is transformative fiction.
le nubian - Jul 21, 2010 4:38:45 pm PDT #14497 of 25501
"And to be clear, I am the hell. And the high water."
oh, I see. how many cells are in the row, roughly?
§ ita § - Jul 21, 2010 4:59:20 pm PDT #14498 of 25501
Well not canonically, no, but this is transformative fiction.
Fifteen or so?
le nubian - Jul 21, 2010 5:25:52 pm PDT #14499 of 25501
"And to be clear, I am the hell. And the high water."
ita, can you import the document into google docs? there are Hlookup commands and vlookup commands that should be able to do what you want.
§ ita § - Jul 21, 2010 5:59:25 pm PDT #14500 of 25501
Well not canonically, no, but this is transformative fiction.
Hello? Why am I not using hlookup? I use vlookup all the time.
I will get on that tomorrow.
§ ita § - Jul 22, 2010 5:54:14 am PDT #14501 of 25501
Well not canonically, no, but this is transformative fiction.
Wait, will hlookup look within the string? Shit I have so little time between meetings today.
Gudanov - Jul 22, 2010 5:58:25 am PDT #14502 of 25501
Coding and Sleeping
Even with a Sansa clip, I'd have no way to get the files from the Internet to the device since Overdrive for Mac only recognizes mp3s.
Ah, I didn't think about that aspect of the problem. Yikes, I can't really think of a way around that unless the Overdrive folks can get their app to deal with the WMA aspect, which, I don't see Apple approving an app that does WMA DRM.
Jon B. - Jul 22, 2010 6:10:40 am PDT #14503 of 25501
A turkey in every toilet -- only in America!
Wait, will hlookup look within the string?
No. I still think a one line macro is the simplest way to go.
le nubian - Jul 22, 2010 6:22:03 am PDT #14504 of 25501
"And to be clear, I am the hell. And the high water."
Jon B. - Jul 22, 2010 7:07:53 am PDT #14505 of 25501
A turkey in every toilet -- only in America!
I meant MS Excel. I don't know from Open Office.