Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have used the VLookup function on an invoice that will print the price and
description of an item when the item number is typed in. I want to removed the #N/A from the invoice when the lines are blank. I was told to use the IF function. My lookup function is =VLOOKUP(A24,Product!A8:D14,2) If I add the IF function to it-- would it look like =IF(A24="","")=VLOOKUP(A24,Product!A8:D14,2) ? Or just where would the IF formula go and did I type it correctly to say if the cell is empty? Thanks Bev |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can we use multiple if with VLookup function | Excel Worksheet Functions | |||
vlookup Function Help Needed | Excel Worksheet Functions | |||
Pastable function using VLOOKUP? | Excel Worksheet Functions | |||
format cell based on results of vlookup function | Excel Worksheet Functions | |||
Vlookup w/Date Function | Excel Worksheet Functions |