can a formula match text to the left , then match it with another text and return value?
Hello. i`m working on something for company, but i`m not an expert at excel at all. but i was woundring if D3 in "TV SCREEN" can match the text in A3, and then if it find a match in Sheet1 column J, and then post the number in column D left of it? i will add the workbookhope someone knows how this works :D
The data is linked and not showing in your sample
can you load a sample without links and the data
Not sure what this means exactlybut i was woundring if D3 in "TV SCREEN" can match the text in A3,
You cna use a vlookup() or an index/match to look up values
so you can lookup a number in A3 and lookup in column J
BUT without the example I'm a little lost
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks