vlookup nested formula

		Microsoft Office Forums > Microsoft Excel > Excel
vlookup nested formula

FAQ

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 »

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 11:43 PM.