Menu

Help create a IF statement to look to to seperate vookup data sour

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

paul

paul is offline

external usenet poster

Posts: 247

Default

Help create a IF statement to look to to seperate vookup data sour

answers at your other post
--
paul

remove nospam for email addy!

"Scottinphx" wrote:

Can someone help me build a statement that will look to one vlookup table to
find data, and if no data exists, go to a second vlookup table to find the
data (data will always be present in this second table). Here are my 2
individual vlookup statements:

=VLOOKUP($F15,SHRINKS,6,false)

=VLOOKUP($F15,STORES_TY_PL,false)

I appreciate the help.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Inputting data to one worksheet for it effect another	daedalus1	Excel Discussion (Misc queries)	1	June 25th 06 04:39 PM
How do I create a link between columns from a data chart?	Sara	Excel Discussion (Misc queries)	1	June 2nd 06 06:51 PM
Displaying data from seperate sheet upon drop down box entry	keeper	Excel Worksheet Functions	1	May 19th 06 07:29 PM
Inserting a new line when external data changes	Rental Man	Excel Discussion (Misc queries)	0	January 11th 06 07:05 PM
Reference multiple cells in if statement	PAR	Excel Worksheet Functions	1	June 10th 05 06:28 AM

All times are GMT +1. The time now is 01:52 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement