extracting data in a raw

[ahhhmed]

Hi all,

I have a worksheet A1:F10 which contains data text and numerals.


In A15 I may choose any value from A1 to A10


I want a formula that displays the values that are in the same raw as the value I choose from A


I hope my explanation is understood.


All help is highly appreciated

 

[prasaddn]

Hi Ahhhmed,


why not try a VLookup() ??


Regards,

Prasad DN

 

[Luke M]

To expand on prasaddn's idea, this formula:

=VLOOKUP($A15,$A$1:$F$10,COLUMN(B$1),FALSE)


Should work to bring over the info from col B. Copy it to the right to bring over the other columns.


Just in the interest of showing alternatives, another formula would be:

=INDEX(B$1:B$10,MATCH($A15,$A$1:$A$10,0))

 

[ahhhmed]

Thanks all,

Luke M, the VLOOKUP formula is OK if I chose only one value in A15.

Now How can we develop this if I have a list A15:A25 and I chose to put a value say in A17 and another value in A20 and yet another value in A23? All values are taken from A1:A10.

 

[prasaddn]

copy Luke's formula in all the rows where you need data to be fetched.

 

[ahhhmed]

OK, Thank you very much.