If lookup function

Microsoft Office Forums

		Microsoft Office Forums > Microsoft Excel > Excel
If lookup function

Reply

#1

Old

03-08-2013, 10:12 AM

Pecoflyer

Pecoflyer is offline

If lookup function

Windows 7 64bit If lookup function

If lookup function

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Default

Hi
try =IF(AS7, LOOKUP(AS7, Sheet3!$A$1:$B$25), "exact")

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Reply With Quote

#2

Old

03-09-2013, 05:21 PM

samc

samc is offline

If lookup function

Windows 7 64bit If lookup function

If lookup function

Office 2010 64bit

Novice

If lookup function

Join Date: Mar 2013

Posts: 2

samc is on a distinguished road

Default

Hi. I think I solved the problem. I didn't need an if function:

=VLOOKUP(AS6, Sheet3!$A$1:$B$25, 2,FALSE)

Thanks.

Reply With Quote

Reply

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup Macro	Cardinal2	Excel Programming	2	02-05-2013 05:50 PM
Lookup	angie.chang	Excel	1	07-27-2012 09:45 PM
Possible Lookup	Karen222	Excel	3	01-10-2012 05:41 AM
LookUp	aztiguen24	Excel	5	05-24-2011 03:57 AM
Using the LOOKUP Command	Grapejuice	Excel	2	10-15-2008 02:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:45 PM.