hI ALL
How do I write an IF function to say this is a match if I have values like this in columns H and I?
column H column I
P240 240 Gm
170G 170 Gm
thank you!
hI ALL
How do I write an IF function to say this is a match if I have values like this in columns H and I?
column H column I
P240 240 Gm
170G 170 Gm
thank you!
Last edited by rayted; 01-17-2023 at 07:28 AM.
Thanks,
R.
Please attach a sample sheet, with a few more rows, expected results and an explanation WHY certain columns should be considered a match.
Is it a case of finding matching numbers?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
If so... are the matches in the same row... or different rows?
No reply. a guess.
it will be incorrect. Please supply a more comprehensive sample.
Hi Glenn
Sorry - I was putting the sample sheet together It's in different rows but same columns.
I just want numbers to match......
Where are the expected results?
It seems that I attached the wrong file last time... what an idiot.
You didn't tell us what you wanted to see as expected answers... so this is a guess.
Formula:Please Login or Register to view this content.
It returns Yes if the number in the LEFT column has a match in the RIGHT column. If that's not what you want... you'll need to tell us what you DO want!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks