Compare text strings in two columns and return text from adjacent cell

**mohitroshan** · 02-28-2013, 03:54 AM

how to Chk the text string in particular cell, compare it with a super set column and get the full from of the text string from another corresponsing column and the output will be corresponsing full form of the chked text string?

**Pepe Le Mokko** · 02-28-2013, 04:28 AM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**mohitroshan** · 02-28-2013, 04:33 AM

Sample Work Sheet.xlsx sample work sheet Attachment 217304

**Pepe Le Mokko** · 02-28-2013, 04:36 AM

Try the VLOOKUP function

**mohitroshan** · 02-28-2013, 04:38 AM

tried but not able to implement it properly. any suggestion

**mohitroshan** · 02-28-2013, 05:15 AM

error, it is showing #N/A. =VLOOKUP($C1,$A$1:$B$250,2,FALSE)
Sample Work Sheet.xlsx

**Pepe Le Mokko** · 02-28-2013, 11:27 AM

That is because some strings in col A have a space at the end ( use the LEN function to verify this f.i. with "JP"
Try

Please Login or Register  to view this content.

Compare text strings in two columns and return text from adjacent cell

LinkBack

Thread Tools

Rate This Thread

Display

Compare text strings in two columns and return text from adjacent cell

Re: Compare text strings in two columns and return text from adjacent cell

Re: Compare text strings in two columns and return text from adjacent cell

Re: Compare text strings in two columns and return text from adjacent cell

Re: Compare text strings in two columns and return text from adjacent cell

Re: Compare text strings in two columns and return text from adjacent cell

Re: Compare text strings in two columns and return text from adjacent cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions