LinkBack URL
About LinkBacks
Try VLOOKUP again but with this small modification
=VLOOKUP(B2,SHEET2!$A$1:$B$100,2,FALSE).
The previous example was trying to look in the second column of a single column array!
Hence the #REF error.
Mark.
Try VLOOKUP again but with this small modification
=VLOOKUP(B2,SHEET2!$A$1:$B$100,2,FALSE).
The previous example was trying to look in the second column of a single column array!
Hence the #REF error.
Mark.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks