=IF(ISBLANK($A70),"",VLOOKUP($A70,'2015Quotes'!$A$2:$J$1000,COLUMN(B1),FALSE))Try this and copy![]()
=IF(ISBLANK($A70),"",VLOOKUP($A70,'2015Quotes'!$A$2:$J$1000,COLUMN(B1),FALSE))
=IF(ISBLANK($A70),"",VLOOKUP($A70,'2015Quotes'!$A$2:$J$1000,COLUMN(B1),FALSE))Try this and copy![]()
=IF(ISBLANK($A70),"",VLOOKUP($A70,'2015Quotes'!$A$2:$J$1000,COLUMN(B1),FALSE))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks