lookup multiple values in multiple columns to return a result

**AYAHOO123** · 04-11-2013, 06:35 PM

Hello,

Given 2 variables (Name and Port) I want get a result (Note). The persons name may show up more than once in the list with different accounts. there MAY be multiple accounts in different columns.
The data set cannot be changed as its a feed from outlook maintained by others with a lot of other info. I think IF/OR statments nested inside a VLOOKUP are needed but I dont know where to start....

Eg.
If I have "Jamie" and account "LO1100US" I want the result to show "requirement".
If I have "Jamie" and account "LO1100" I want the result to show "requirement".
If I have "Jamie" and account "MI4051" I want the result to show 0 or blank or NA

Name Port1 Port2 Port3 Note
Jamie MI4051
Lisa AS1600
Michael FE1300 FE1301
Matt FE1300 FE1301
Marisa HY1000 HY1001 no requirement
Lisa HY1000 HY1001 no requirement
James HY1000 HY1001 HY5060 no requirement
Jerry HY5060
Craig HY5060
Marianne HY1000 HY1001
Barb LO1100 LO1100US requirement
Jamie LO1100 LO1100US requirement

Thanks!!
A

**AYAHOO123** · 04-11-2013, 06:40 PM

Oops, my data was in columns when I pasted it.....

**mehmetcik** · 04-11-2013, 06:45 PM

Hi

Your requirement is not fully understood.

I have a macro that will highlight all ocurrances of a string in a file.
I have a modified version that checks an offset cell for a second string. I suppose that could be modified to search an entire row or column for your account number

So I can find all occurances of the username that is also linked to a valid account number..........

But you have not explained what do do with that information.

You would need to post before and after scenarios for me to be able to help you.

**AYAHOO123** · 04-11-2013, 07:53 PM

Hi! sorry for the confusion

I have attached an example of what I'm trying to do.

I type in the name cell(H4) as well as the Account cell (H7) I want the note section to auto populate with the corresponding note (information in column F)

so I need to lookup Name(Column B), AND lookup Account(column C OR D OR E) = Note/blank(Column F)

Example.xlsx

If I fill in "Jamie" and account "LO1100US" I want the notes section to show "call ahead".
If I fill in "Jamie" and account "LO1100" I want the notes section to show "call ahead".
If I fill in "Jamie" and account "MI4051" I want the notes section to show 0 or blank or NA