| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedded If Function in a Vlookup Function | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
![The Needy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
