Find cell according to text

[madocar]

Hi guys,

I want to find particular cell according to text by using formulas in all range. Lets say the cell called "CAR"
That particular cell would be a reference point for another formula "OFFSET"

Is this even possible?

Thanks

 

[Luke M]

Probably. You haven't given very much info, so I'm not exactly sure what you layout is or what you're trying to accomplish. Can you elaborate more, paste some sample data, or upload a file?

 

[SirJB7]

Hi, madocar!
Wanna find your CAR? 2 options, go to the garage or try this:
=UCASE(LEFT(nick,3))
Regards!

 

[Sajan]

Hello madocar,
If finding your car as SirJB7 outlines above was not a satisfactory experience, you could use functions such as FIND and MATCH to locate stuff, and if needed, feed it to OFFSET.

 

[Faseeh]

Please provide some sample data...

 

[SirJB7]

@Faseeh
Hi!
Blue sapphire, model 2010, sedan, 4 wheels (1 new), air conditioning without freon (next week charge scheduled), a bad burnt CD pending with a red ribbon from the rearview mirror aside to a couple of big plush dices, ...
Last seen: where it was left, of course, but don't ask for more precisions!
Regards!

 

[SirJB7]

@madocar
Hi!
Hope you don't mind that these guys had hijacked your post to make jokes.
I apologize in their name, if so.
Regards!

 

[SirJB7]

@Faseeh
Hi!
If any doubt or finding more than one alike, check the seat covers, more like leopard than animal print. :D
Regards!

 

[Abhijeet R. Joshi]

Try calling 911, maybe of some help...

 

[madocar]

File with comments what I want to do is in attachment
Hopefuly now it is more understandable

 

[Luke M]

This looks a lot like the other question you posted, which was answered.
http://chandoo.org/forum/threads/multisheet.12840/
Is there something new to the problem that I'm not seeing, or wrong with the answers SirJB7 or myself gave you?

 

[NARAYANK991]

Hi ,

The problem is that in the individual sheets you have the header as "Car " , with a space after the r ; first remove this space.

Once this is done , put the following formula in B3 , and copy it across and down in each of the tabs Car , Furniture and Watches :

=INDEX(INDIRECT($A3&"!"&"$A$2:$D$13"),MATCH(B$2,INDIRECT($A3&"!"&"$A$2:$A$13"),0),0) INDEX(INDIRECT($A3&"!"&"$B$1:$D$13"),0,MATCH($B$1,INDIRECT($A3&"!"&"$B$1:$D$1"),0))

Narayan

 

[SirJB7]

@Luke M
Hi!
I think that both approaches (VBA and formulas) were fully covered at the original post, and neither of them received not even a single comment or question. Shouldn't it be considered as solved?
Regards!
PS: Or perhaps the car has run out of gas...