View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
The Needy[_2_] The Needy[_2_] is offline
external usenet poster
 
Posts: 6
Default vlookup function

Hi

I have to add the amount of books of the same title from two different
libraries using vlookup because each library has its own amount of that
title, but some books may not be available in those two libraries and I need
to put "Not Available". I am told to use =IF(ISNA(VLOOKUP(*****), 0,
VLOOKUP(*****) ), but idk how to use it in my situation. Please help
me!!!!!!!!!! I need this ASAP!!!!!!!!!! Thank you!!!!!!!!!!