I would like to Compare two table Columns
In first Table, the Columns are extracted from a String and I have a hard time to compare the results of this.
Please see the attached File for description.
I would like to Compare two table Columns
In first Table, the Columns are extracted from a String and I have a hard time to compare the results of this.
Please see the attached File for description.
This should get you strated. In C3 copied down:
=IFERROR(VLOOKUP(VALUE(B3),Table2,2,0),IF(B3="","Text2","Text1"))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sorry, I have attached the file and explained again
I am looking only for cells with value in (for empty cells I do not want any results)
Change of requirement accounted for here:
=IF(B3="","",IFERROR(IFNA(VLOOKUP(VALUE(B3),Table2,2,0),"Text2"),"Text1"))
Thank you very much, work super
Yes! You're welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks