hi!
i am having data in A1:C5.
can i findout the value in COL "A" or COL "B"
corresponding to my lookup value in COL "C"-?
hlp pl!?
-via135
hi!
i am having data in A1:C5.
can i findout the value in COL "A" or COL "B"
corresponding to my lookup value in COL "C"-?
hlp pl!?
-via135
For 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:
> hi!
>
> i am having data in A1:C5.
> can i findout the value in COL "A" or COL "B"
> corresponding to my lookup value in COL "C"-?
>
> hlp pl!?
>
> -via135
>
>
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
"via135" <[email protected]> wrote in
message news:[email protected]...
>
> hi!
>
> i am having data in A1:C5.
> can i findout the value in COL "A" or COL "B"
> corresponding to my lookup value in COL "C"-?
>
> hlp pl!?
>
> -via135
>
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile:
> http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=538287
>
thks..Aladin & Biff..!!!
-via135
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks