Lookup, but which type?

[Akashwani]

Hi,

Before I have to call in the builders to replace the wall I'm banging my head on, can someone point me in the right direction to solving this?

I don't want the actual formula (yet), just a pointer.
I'm probably missing the bl**dy obvious here.....

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	*	*	*	*	*	*	*	*	*	*	*
2	Dog	Cat	Pig	Horse	Fish	Panda	Rat	Mouse	Moose	Cow	Bull
3	*	*	*	*	*	*	*	*	*	*	*
4	*	*	*	*	*	*	*	Fish	Panda	*	*
Sheet3

If I type Fish in H4, which type of formula do I require in I4 to return Panda?
Like wise If I type Dog in H4 I want to return Cat in I4.

I look forward to the sniggers and help

Thanks

Ak

 

[Aladin Akyurek]

Ah,
and here's me thinking that I'm going to get 255 z's,

Thanks for your time people.

Now for some DIY!!
Anyone have any pollyfilla?

Ak

REPT("z",255) creates a lexically BigStr in analogy to BigNum, Excel's
constant of 9.99999999999999E+307, which are used as look up values
in order to fetch the last text value and the last numeric value, respectively,
in references of interest. Here are two relevant links:

http://www.mrexcel.com/forum/showthread.php?t=102091

http://www.mrexcel.com/forum/showthread.php?t=310278 (post #7)