LinkBack URL
About LinkBacks
Hi Guys,
I need to get the output(col B of sheet 1) looking at the input (Col A of sheet 1) with the help of the mapping table sheet.
Is this possible?
Thanks in advance
Hi Guys,
I need to get the output(col B of sheet 1) looking at the input (Col A of sheet 1) with the help of the mapping table sheet.
Is this possible?
Thanks in advance
I've opened up the spreadsheet but I'm confused on exactly what you are asking. Are you saying you need Column B to show values of Column A based off of the info from the mapping table sheet?
Edit: If so, a VLOOKUP formula will work for this. Although, this formula will not work with multiple countries in the same cell (ex. France;India).
Formula:
Please Login or Register to view this content.
Last edited by chrisbeaudet; 03-12-2017 at 12:03 AM.
If my answer helped, say thanks. Add reputation.
Hi chrisbeaudet,
Yes, you interpreted it right. I am aware of the vlookup formula and i tried it myself before posting this thread as i wasn't getting the necessary output. Is there any other way/formula to make this possible?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks