![]() |
#1
|
|||
|
|||
![]()
Hi,
I have two columns, on the same sheet, and I wnat to look at the values in one column and see if a given value is in another; and then in a third column show that it is in the first column, and the cell that it is in. If this is not possible, it can just show True or False. For example; Quote:
Last edited by itmaster; 12-12-2014 at 06:52 AM. Reason: Table culmped together |
#2
|
||||
|
||||
![]()
Hi
do you really need the cell reference if true? What would you do with it?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
Well it would be nice, if I had a lage table and other collumns like dates that I wanted to compare, but that is okay how would you do this with True. I tryed formulas and Vlookups and I am doing something wrong I canot get it. Do you have any idea of what I can do?
Thank you |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want a quotient using a constant to show up in column c each time a number is added to column b | fibbermcghee | Excel | 2 | 12-09-2014 05:48 PM |
![]() |
ScottA | Excel Programming | 3 | 05-06-2014 12:49 PM |
![]() |
Mr Davo | Excel | 1 | 10-29-2012 01:07 AM |
Can I change the horizontal scrollbar to scroll smoothly rather than column by column | carpat | Excel | 0 | 01-10-2012 09:34 AM |
![]() |
pdfaust | Excel | 2 | 02-03-2011 03:02 PM |