Vlookup
Closed
reshu
-
Mar 24, 2011 at 05:02 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 24, 2011 at 05:47 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 24, 2011 at 05:47 AM
2 responses
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 24, 2011 at 05:08 AM
Mar 24, 2011 at 05:08 AM
Can you please elobrate your problem, what you to look up in third column adn with reference to what.
if you simple want to lookup first column with reference to the same, the vlookup formula is as:
=VLOOKUP(A:A,A:A,1,FALSE)
if you simple want to lookup first column with reference to the same, the vlookup formula is as:
=VLOOKUP(A:A,A:A,1,FALSE)
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 24, 2011 at 05:47 AM
Mar 24, 2011 at 05:47 AM
As per my understanding
if there is #N/A in column 2, result column is blank
and if
column 2 has value than result column having a value of column 3 with respect to column 1.
if i am right
than first replace #N/A by blank using find and replace,
than use this formula.
= if (B2 ="" ,"" , VLOOKUP(A2,A:C,3,FALSE))
if not
Please be more specific regarding your problem, :)
Cheers!
Rahul
if there is #N/A in column 2, result column is blank
and if
column 2 has value than result column having a value of column 3 with respect to column 1.
if i am right
than first replace #N/A by blank using find and replace,
than use this formula.
= if (B2 ="" ,"" , VLOOKUP(A2,A:C,3,FALSE))
if not
Please be more specific regarding your problem, :)
Cheers!
Rahul
Mar 24, 2011 at 05:26 AM
suresh dipak suresh suresh
lester jayraj lester lester
nitin lullu nitin nitin
dipak #N/A
jayraj #N/A
lullu #N/A
Note:-
U r given formula is normal that is col3 to looking in col1 only, but I want to lookup col3 with col1 & col2 at a time where #n/a data is not in col1 but it is col2 I want result in result column. So, please help my to solve this problem