Multiple if(or) or maybe I need if(and) Can I make this work?

[corppunishment11]

I've written nesting if(ands) but I'm wondering if I can have an If(or do what I want it to.

I'm looking to have one formula look at a set cell position A2 on sheet 1 "Bob Builder" and then compare that to sheet3 A2:A1000. If it's "Bob Builder" then return the values in sheet3 B2:B1000.

But I want that formula to use whatever name is in A2 on sheet 1 and return the value from sheet 3.

Example:

if sheet 1 A2 is "Bob Builder" and "Bob Builder" is on sheet3 A2:A1000 return value in sheet3 B2:B1000. If sheet 1 A2 is "Al Bore" then do the same thing....

Does this make sense? Can I have a nesting statement pull like that?

 

[Fluff]

You can do that with Vlookup https://exceljet.net/excel-functions/excel-vlookup-function
or Index/Match https://exceljet.net/index-and-match

 

[corppunishment11]

What I need is to have a user choose the name on sheet one "Bob" then have it pull the data from sheet 3 for Bob.

VLookups just present the data. I'm looking to make it so the user has to choose the initial data point. The users only care about the data associated with the person they are reporting on.

Does that help? I have 7 names that correspond to 10,000 lines of different data on sheet 3

 

[Fluff]

Is this just a continuation of this https://www.mrexcel.com/forum/excel-questions/1082600-im-truly-stuck.html#post5202313

 

[corppunishment11]

I see what you are saying. I replied to the other thread you assisted on.