vlookup nested formula

		Microsoft Office Forums > Microsoft Excel > Excel
vlookup nested formula

FAQ

Mark Forums Read

Thread Tools

Display Modes

09-13-2018, 08:39 AM

paxon

Windows XP vlookup nested formula

Office 2007

Novice

Join Date: Feb 2016

Posts: 13

vlookup nested formula

How can I tell the vlookup, if the vlook up ISNA give me "0", if is = to cell"A1" give me YES else NO (as per sheet1)

I would like to see in
cell B 2 -4 yes

cell B3 no.

Thanks

Attached Files

Supplier.xlsx (52.6 KB, 13 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLookup and Nested IFs or Index Function	SavGDK	Excel	10	04-08-2016 10:06 PM
nested formula using IF & AND	paxon	Excel	3	02-18-2016 05:32 AM
using if and nested vlookup	wentworth16238	Excel	5	06-14-2015 12:59 PM
Nested Vlookup Help	asluder2000	Excel	2	11-14-2014 11:00 PM
Nested vlookup with varable tables!	Dave Jones	Excel	0	08-30-2012 09:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:57 AM.