HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION
|
Not sure which part of the left function you want it nested in... but it would probably look something like this... =LEFT(VLOOKUP(C3,$A$1:$B$100,2,FALSE),4) or this... =LEFT(C2,VLOOKUP(C3,$A$1:$B$100,2,FALSE)) depending on if you were looking to pull in the text value or the numeric value with the VLOOKUP function. -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=390712 |
All times are GMT +1. The time now is 08:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com