LinkBack URL
About LinkBacks
excellearner121 
=VLOOKUP($BA$2,'S:\[abcd.xlsx] Database'!$S:$T,2,FALSE)
this formula does not copy accross. instead of picking its respective column its taking BA column for all cells.
Can some one please help
=VLOOKUP($BA$2,'S:\[abcd.xlsx] Database'!$S:$T,2,FALSE)
this formula does not copy accross. instead of picking its respective column its taking BA column for all cells.
Can some one please help
take the $ away from BA
ie
=VLOOKUP(BA$2,'S:\[abcd.xlsx] Database'!$S:$T,2,FALSE)
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
if it's a s you say, drop the dollar sign ($) off the referencing (I'm assuming you want the vlookup value to change as you drag across) :
Formula:
=VLOOKUP(BA$2,'S:\[abcd.xlsx] Database'!$S:$T,2,FALSE)
If this does not work, I suggest a sample workbook, with at least a few expected results
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Thanks guys that worked perfectly!
Thanks Alot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks