software

hi!

i am having data in A1:C5.
can i findout the value in COL quot;Aquot; or COL quot;Bquot;
corresponding to my lookup value in COL quot;Cquot;-?

hlp pl!?

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=538287For unsorted data...

=INDEX(ReturnRange,MATCH(Value,MatchRange,0))

For example:

=INDEX(A:A,MATCH(E2,C:C,0))

where E2 houses a value you want to look up.

via135 wrote:
gt; hi!
gt;
gt; i am having data in A1:C5.
gt; can i findout the value in COL quot;Aquot; or COL quot;Bquot;
gt; corresponding to my lookup value in COL quot;Cquot;-?
gt;
gt; hlp pl!?
gt;
gt; -via135
gt;
gt;

Hi!

To return the value from column A:

=INDEX(A1:A5,MATCH(lookup_value,C1:C5,0))

To return the value from column B:

=INDEX(B1:B5,MATCH(lookup_value,C1:C5,0))

Or, index both columns A and B and use a cell to hold the column_number
argument:

H1 = 1 or 2

=INDEX(A1:B5,MATCH(lookup_value,C1:C5,0),H1)

Biff

quot;via135quot; gt; wrote in
message ...
gt;
gt; hi!
gt;
gt; i am having data in A1:C5.
gt; can i findout the value in COL quot;Aquot; or COL quot;Bquot;
gt; corresponding to my lookup value in COL quot;Cquot;-?
gt;
gt; hlp pl!?
gt;
gt; -via135
gt;
gt;
gt; --
gt; via135
gt; ------------------------------------------------------------------------
gt; via135's Profile:
gt; www.excelforum.com/member.php...oamp;userid=26725
gt; View this thread: www.excelforum.com/showthread...hreadid=538287
gt;

thks..Aladin amp; Biff..!!!

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=538287