Compare values in two columns and return the value from third [Solved/Closed]
ramdubai2
Posts Monday March 11, 2013Registration date
March 11, 2013
Last seen
-
Mar 11, 2013 at 01:34 AM - Latest reply: keshav
- Sep 7, 2016 at 02:30 AM
I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need to return the value in the third column to the fourth column.
Can anybody help??? Thanks in advance.
I have two columns A and B I want to match them, when they do match at a cell I want to return a value from a third column to a fourth column..the value needed from the third column is in the same row as the matched value in column B how can I do that please?
sir
if i have a column a and in column we have two or more same no.(like ab-230,ab-230),randomaly. i want to search them and add there value.
ex:
A B C
ab-230 2 4
an-25 4 7
ab-230 3 6
I have two an excel with 3 sheets. One sheet has desc column, another sheet has id column and desc column. now I have to compare two descs and fetch the id value in another column.
example
zone1 zone2 id
hyd blr 1 3
hyd hyd 2 1
blr che 3 4
che tec 4 0
if zone1 value wherever occur in the zone2, then corresponding id value has to display in D column .
As I said in my previous post, if there is more then one value to return, then use the second formula. You will need to change the formula as in the first post you wanted to return a value from the third column.
Hi Kevin - this formula is exactly what I need in my sheet - I've replicated the above example and it works perfectly - but in my own sheet the data is located in columns B, C & F with the header rows at Row 4. I cant figure out how I can transpose the above formula into my own sheet. I'm guessing it is something to do with the ROW elements.
I am looking to check the criteria in C & F and then return the value in B
has helped 1680 users this month
Perhaps something along these lines.
=IF(A1=B1,C1,"")
if i have a column a and in column we have two or more same no.(like ab-230,ab-230),randomaly. i want to search them and add there value.
ex:
A B C
ab-230 2 4
an-25 4 7
ab-230 3 6
we want to add column a like
A b C
ab-230 5 10
pls reply me
I have two an excel with 3 sheets. One sheet has desc column, another sheet has id column and desc column. now I have to compare two descs and fetch the id value in another column.
example
zone1 zone2 id
hyd blr 1 3
hyd hyd 2 1
blr che 3 4
che tec 4 0
if zone1 value wherever occur in the zone2, then corresponding id value has to display in D column .
Please advise.
Regards
Prabhakar