Help combing search and vlookup formula

[easybpw]

Hi and thanks for your assistance. I need to take the results from the vlookup formula below and use that for my search formula.

=VLOOKUP(Info!H2,DATA,3,FALSE)

combine with

=IF(ISNUMBER(SEARCH(Info!H2,$I4))=TRUE,"PNC REST","")

The Info!H2 would be the result from my vlookup formula. I've had many failed attempts to combine these together. Any help would be appreciated.

 

[Fluff]

Does the vlookup return text or is it a number?

 

[easybpw]

Does the vlookup return text or is it a number?

Sorry for the delayed response. It returns a number.

 

[Zaifee]

To combine the result of your VLOOKUP formula with the SEARCH formula, you can nest the VLOOKUP formula inside the SEARCH formula. Here's the modified formula:

=IF(ISNUMBER(SEARCH(VLOOKUP(Info!H2, DATA, 3, FALSE),$I4)),"PNC REST","")

This formula will perform a VLOOKUP using the value in Info!H2 as the lookup value, searching for a match in the DATA range. The result of the VLOOKUP (which is the value in the third column of the DATA range) is then used as the search string in the SEARCH function. If the search string is found in cell $I4, it will return "PNC REST". Otherwise, it will return an empty string.

Make sure to adjust the ranges and references in the formula to fit your specific data structure.

 

[Fluff]

@Zaifee That formula has already been suggested & the OP said it didn't work.

Sorry for the delayed response. It returns a number.

In that case the formula should work. Do the two formula in separate cells work?

 

[easybpw]

@Zaifee That formula has already been suggested & the OP said it didn't work.

In that case the formula should work. Do the two formula in separate cells work?

Thank you for all the helpful tips. I did what you alluded to by trying each formula by itself and I found my problem. It now works. Small detail that I missed. Thanks again!

 

[Fluff]

Glad you sorted it & thanks for letting us know.