I am trying to use the number in A2 to find the matching number in column B. Then I want to use that found cell in column B to locate and take the contents of the cells in the same row but to the right in column C and column D to then populate E2
the value in A2 is a link from a different sheet but same workbook
in the attached example E2 should have the contents of C12 & D12
Mega thanks in advance
enter this in E2
Formula:
Please Login or Register to view this content.
Thanks for the quick response, IT WORKS GREAT THANK YOU!!
Or just this...
=VLOOKUP($A$2,$B$2:$D$97,2,0)&" "&VLOOKUP($A$2,$B$2:$D$97,3,0)
(don't need to use CONCATENATE, just join with &)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks