Try this...
=IF($A70="","",VLOOKUP($A70,'2015Quotes'!$A$2:$J$1000,COLUMNS($A1:A1)+1,0))
Try this...
=IF($A70="","",VLOOKUP($A70,'2015Quotes'!$A$2:$J$1000,COLUMNS($A1:A1)+1,0))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks