Find text based on column number

[loverfellow]

I am actually using vlookup function. Here is formula:
=+VLOOKUP(B10,'Selected (2)'!B8:IV56,3,0)

Now, for column number, I want to search some particular text in a row and if the text matches, then i want the result to be column number so that my vlookup function can work properly.

I am in a little bit hurry, because my meeting is coming ahead. So, I would be obliged if someone could answer this.

 

[Colin Legg]

One general approach would be this:

=INDEX('Selected (2)'!B8:IV56,
    MATCH(B10,'Selected (2)'!B8:B56,0),
    MATCH(B11,'Selected (2)'!B8:IV8,0))

Where
B10 contains the text for the Row you want to lookup
B11 contains the text for the Column you want to lookup

'Selected (2)'!B8:IV56 is the entire lookup table including headers
'Selected (2)'!B8:B56 is the first row of the lookup table
'Selected (2)'!B8:IV8 is the first column of the lookup table

 

[loverfellow]

Thanks for quick reply.
Sorry, I didn't get it. I will be more specific.
=+VLOOKUP(B10,'Selected (2)'!B8:IV56,3,0)

Now, for column number, I want to search text "1A3" from this range "'Selected (2)'!C8:IH8", and I want the result to be column number where the "1A3" text is found.

Waiting for reply...

 

[Colin Legg]

I believe it would be this:

=INDEX('Selected (2)'!B8:IV56,
    MATCH(B10,'Selected (2)'!B8:B56,0),
    MATCH("1A3",'Selected (2)'!B8:IV8,0))

This formula replaces your entire VLOOKUP formula.

 

[loverfellow]

A great many thanks buddy.
You saved my life.
There are excel legends like you in this forum. I hope to become one day.