Posted to microsoft.public.excel.worksheet.functions

Matt

external usenet poster

Posts: 516

Two VLookups in one arguement

Here is what I want the formula to do:
If the first VLookup arguement does not return any results, have another
VLookup formula look in another sheet. This is a simple example of the
formula:

=IF(ISNA(VLOOKUP(A1,A!$A$1:A!B3,2,FALSE),Vlookup(A 1,B!A1:B!B4,2,False),0))

Any help would be greatly appreciated.

Thanks. ME.

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
Do VLOOKUPs require the applicable other files to be open?	ulupi	Excel Discussion (Misc queries)	1	December 20th 06 04:43 PM
VLOOKUPS: Limits on # per sheet?	Trey	Excel Discussion (Misc queries)	2	March 16th 06 03:19 AM
Sum a row of multiple vlookups	jtgostars	Excel Worksheet Functions	1	December 10th 05 06:37 PM
Vlookups	wmjenner	Excel Worksheet Functions	2	November 23rd 04 10:39 PM

All times are GMT +1. The time now is 03:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us