vlookup only on data which passes another test

[hiz]

Hi,
im new here ad would like some help please!

Im trying to perform a vlookup but only searching through rows which have a matching text string.

Column A - list of text "Yes" or "No"
Column B - list of server IP addresses
Column C - server name

Id like to do a vlookup (or similar) from another sheet so that it matches the server IP address, returns the name BUT ONLY for the rows where column A is "Yes".

I've got the standard vlookup running OK but its not doing the Yes/No check.

Any advice welcomed as I've confused myself looking at nested vookups, match statements and so on!

Thanks!

 

[Gerald Higgins]

Hi, welcome to the board.

Do you mean like this ?

=if(A1="YES",vlookup(....),"something else")

Replace .... with your vlookup formula.
Replace "something else" with whatever you want to do if A1 is not = "YES"

 

[Haseeb Avarakkan]

Or is this do you mean?

Confirmed with Control+Shift+Enter, not just Enter.

=INDEX(ServerName,MATCH(1,IF(ListofText="Yes",IF(IPIddress=A1,1)),0))

 

[hiz]

Hi, welcome to the board.

Do you mean like this ?

=if(A1="YES",vlookup(....),"something else")

Replace .... with your vlookup formula.
Replace "something else" with whatever you want to do if A1 is not = "YES"

Hi, no i dont think thats what I need.

I only need the vlookup to return a value from C, if it finds a match in B. But only if A contains "yes".

One way I guess it to automatically limit the array range to only the rows which has column A containing "yes". Essentially ignoring the rows of data where the value in A is "no".

Does this make more sense?

 

[Gerald Higgins]

Does this make more sense?

Not to me, sorry.

I think it would help if you could give us a small sample of your data (or make up some sample data if you don't want to show real data) together with what exactly you want to do.