Vlookup multiple comma seperated search keys

[Achiles625]

Hey, I am trying to use VLOOKUP to check if any of several comma seperated search keys, located in one cell, are in a range on a another sheet and if so return the value of a a relatively positioned cell.

Example:

In cell L2 the user has typed "Infantry Armor, Axe". I want VLOOKUP to search for "Infantry Armor" or "Axe" in a defined cell range. Now it doesn't have to find both, since terms are seperated into different ranges based on type and the user is only suppossed to type in one terms of each type. In this example one armor and one weapon. This formula is copied, slightly modified in different places, to produce the data for each type of term. I.E. there is a cell for the armor result and a cell for the weapon result and the VLOOKUP function in each cell only references the range for that type in the other sheet.

Here is a link to the sheet. The functions are the battle sheet and the referenced data is in the gear sheet. the nettlesome functions are row two after column K.

https://docs.google.com/spreadsheets...it?usp=sharing

[FDibbins]

Hi, welcome to the forum

(I have come to the conclusion that I do NOT like working with google docs)

Why cant they just keep it simple and only enter 1 item per cell?

[:) Sixthsense :)]

I don't have access to google docs because of company firewall

Can you please attach it in this site?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[FDibbins]

Six, I have the same problem at work, too. At home (now) I can access them, but I dont like them

[:) Sixthsense :)]

but I dont like them

Because again we have to spend time to learn the google spreadsheet functions which differs from excel functions.

It's waste of time for us...

[Achiles625]

Did that work?

[Achiles625]

So anyone got any Ideas on this? I posted the excel file up. Someone please help me! :-(