LinkBack URL
About LinkBacks
formula ..
=VLOOKUP($B$2,sheet1!$A$3:$AA$8,ROWS($A$1:A2)
See attached
formula ..
=VLOOKUP($B$2,sheet1!$A$3:$AA$8,ROWS($A$1:A2)
See attached
Last edited by JohnTopley; 11-01-2015 at 01:58 PM.
can u use it in index match cuz later on we will add more people in sheet 1 the one i sent u was till A6 later on itll be more things and i feel index match is more suitable than vlookup cuz later on we dont hve to change the formula in index match.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks