I need a help on this following situation;
I have 3 columns with unique records. Column 1 has 60 rows & 2nd & 3rd Columns have 90 rows. Values in Column 1 are also appearing in the values of 2nd column. I need to find out values of 1st column in 2nd column & arrive at the corresponding value of 3rd column IN COLUMN 4;
Example:
A B C D
1234 1225 A J
1235 1226 B K
1236 1227 C L
1237 1228 D M
1229 E
1230 F
1231 G
1232 H
1233 I
1234 J
1235 K
1236 L
1237 M
Try
=IFERROR(IF($A2<>"",VLOOKUP($A2,$B$2:$C$14,2,0),""),"")
Re: Comparing 2 columns & returning with the corresponing value of 3rd column
This is similar to what I would like to accomplish as well, but I don't understand the formula well enough to see if it would work for my spreadsheet. 220 rows x 15 columns
I tried =IF(A2="*text*",B2,0) but it doesn't work.
In Column A, I have text.
In Column B, I have the number of times that string of test appears on a report.
In Columns C-0, I would like to check the text in Column A to see if it contains a particular word or string of characters. If it does, I would like the number in Column B to appear in the corresponding column that contains that word or string. If not, then it needs to be 0.
Example
Example.png
Would the same or similar formula work in my spreadsheet as well?
Last edited by luthientinuviel; 02-05-2016 at 12:35 PM.
Hijacked a thread!
Can you post a sample Excel file?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks