Use Like in Vlookup
 

Here is my function:
=IF(ISNA(VLOOKUP(H12,'booked pivot'!G:H,2,FALSE)),0,VLOOKUP(H12,'booked
pivot'!G:H,2,FALSE))

I am trying to get Excel to evaluate this string in cell H12:
"US-MD"

The data looks like this:
Medscape - US-HCP - Cardiology - 728x90 - Top, 03/01/2009
Medscape - US-MD - Cardiology - 120x600 - LR, 03/01/2009

Any ideas on how to do this?


Thanks,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

Use Like in Vlookup
 

Hi,

Try this

=VLOOKUP("*"&H12&"*",'booked pivot'!G:H,2,FALSE)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ryguy7272" wrote in message
...
Here is my function:
=IF(ISNA(VLOOKUP(H12,'booked pivot'!G:H,2,FALSE)),0,VLOOKUP(H12,'booked
pivot'!G:H,2,FALSE))

I am trying to get Excel to evaluate this string in cell H12:
"US-MD"

The data looks like this:
Medscape - US-HCP - Cardiology - 728x90 - Top, 03/01/2009
Medscape - US-MD - Cardiology - 120x600 - LR, 03/01/2009

Any ideas on how to do this?


Thanks,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

Use Like in Vlookup
 

Just to add to Ashish's response...

You may want to make sure that H12 is non-empty--otherwise "**" will match the
first entry.

=if(h12="","",vlookup(....

Ashish Mathur wrote:

Hi,

Try this

=VLOOKUP("*"&H12&"*",'booked pivot'!G:H,2,FALSE)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ryguy7272" wrote in message
...
Here is my function:
=IF(ISNA(VLOOKUP(H12,'booked pivot'!G:H,2,FALSE)),0,VLOOKUP(H12,'booked
pivot'!G:H,2,FALSE))

I am trying to get Excel to evaluate this string in cell H12:
"US-MD"

The data looks like this:
Medscape - US-HCP - Cardiology - 728x90 - Top, 03/01/2009
Medscape - US-MD - Cardiology - 120x600 - LR, 03/01/2009

Any ideas on how to do this?


Thanks,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

--

Dave Peterson

Use Like in Vlookup
 

Are you wanting to return the date?

This is all in one cell in column G ?

Medscape - US-MD - Cardiology - 120x600 - LR

And the date is in column H ?

As long as there is only one instance of US-MD you can use a SUMIF formula:

=SUMIF('booked pivot'!G:G,"*"&H12&"*",'booked pivot'!H:H)

Format as Date


--
Biff
Microsoft Excel MVP


"ryguy7272" wrote in message
...
Here is my function:
=IF(ISNA(VLOOKUP(H12,'booked pivot'!G:H,2,FALSE)),0,VLOOKUP(H12,'booked
pivot'!G:H,2,FALSE))

I am trying to get Excel to evaluate this string in cell H12:
"US-MD"

The data looks like this:
Medscape - US-HCP - Cardiology - 728x90 - Top, 03/01/2009
Medscape - US-MD - Cardiology - 120x600 - LR, 03/01/2009

Any ideas on how to do this?


Thanks,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

Use Like in Vlookup
 

Thanks everyone!!
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"T. Valko" wrote:

Are you wanting to return the date?

This is all in one cell in column G ?

Medscape - US-MD - Cardiology - 120x600 - LR

And the date is in column H ?

As long as there is only one instance of US-MD you can use a SUMIF formula:

=SUMIF('booked pivot'!G:G,"*"&H12&"*",'booked pivot'!H:H)

Format as Date


--
Biff
Microsoft Excel MVP


"ryguy7272" wrote in message
...
Here is my function:
=IF(ISNA(VLOOKUP(H12,'booked pivot'!G:H,2,FALSE)),0,VLOOKUP(H12,'booked
pivot'!G:H,2,FALSE))

I am trying to get Excel to evaluate this string in cell H12:
"US-MD"

The data looks like this:
Medscape - US-HCP - Cardiology - 728x90 - Top, 03/01/2009
Medscape - US-MD - Cardiology - 120x600 - LR, 03/01/2009

Any ideas on how to do this?


Thanks,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.