Posted to microsoft.public.excel.worksheet.functions

andy[_2_]

external usenet poster

Posts: 4

Help Vlook up returning N?A

We are using the following formula and it returns N/A
=IF($A790,IF(VLOOKUP($A79,'BO
Output'!$A$3:$P$2002,4,FALSE)="","",VLOOKUP($A79,' BO
Output'!$A$3:$P$2002,4,FALSE)),"")

How do i use isna function with this formula
--
andy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOK up returning #N/A even though value exists in lookup array	[email protected]	Excel Worksheet Functions	1	September 4th 07 06:56 PM
VLOOK-pivot table expanding want to update vlook automatically	CrimsonPlague29	Excel Worksheet Functions	0	August 8th 07 09:44 PM
VLOOK-pivot table expanding want to update vlook automatically	CrimsonPlague29	Excel Worksheet Functions	0	August 8th 07 09:44 PM
Vlook	bimseun	Excel Worksheet Functions	3	May 27th 06 11:50 PM
VLOOK	Adnan	Excel Worksheet Functions	2	June 18th 05 04:30 PM

All times are GMT +1. The time now is 02:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us