How to find data in a cell??

[INEEDEXCELHELP]

Okay here goes!!

Basically I need a formula that work as below. It's over two sheets and is probably very easy to most of you I just cant get my head round this one!!

If B1 (sheet 1) = "TEXT1" ,FIND the content I1 (sheet 1) within a1:a3000 (sheet 2). If I1 is found in that range i need to know the text in the cell next to the found text.

eg: the text of I1 (sheet 1) was found in cell a234 (sheet 2) so it gives me the text in b234.

Thanks in advance!

 

[INEEDEXCELHELP]

You'd probably want a nested IF statement. Something like this:

=IF(B20="LL MATCH",IF(VLOOKUP(L20,LL!$A$2:$B$3000,2,FALSE),'FEES-BATCHED'!E20,VLOOKUP(L20,LL!$A$2:$B$3000,2,FALSE)),"")

FEES-BATCHED (FEES)

A1	B1	C1	D1	E1
Month	OFFICE1 OR LL MATCHED	FORMULA	OFFICE NAMES	Client code
1	LL MATCH	???	BOBS OFFICE	L7676
1	BOBS OFFICE	???	JEFFS OFFICE	W4545

<tbody>
</tbody>

LL

A1	B1
Client code	Office of Client
L2121	Franks Office
L7676	James' Office
W4545

<tbody>
</tbody>

So it looks at FEES B1 if it says LL MATCH it looks in LL A1 to find a code that matches FEES E1, if it does FEES C1 will show LL B1. However if LL B1 is empty it should display FEES D1.

I hope this makes sense I have tried to explain it as best I can! Thank you again!! I just wish i could work this out myself!

 

[INEEDEXCELHELP]

FEES-BATCHED (FEES)

A1	B1	C1	D1	E1
Month	OFFICE1 OR LL MATCHED	FORMULA	OFFICE NAMES	Client code
1	LL MATCH	???	BOBS OFFICE	L7676
1	BOBS OFFICE	???	JEFFS OFFICE	W4545

<tbody>
</tbody>

LL

A1	B1
Client code	Office of Client
L2121	Franks Office
L7676	James' Office
W4545

<tbody>
</tbody>

So it looks at FEES B1 if it says LL MATCH it looks in LL A1 to find a code that matches FEES E1, if it does FEES C1 will show LL B1. However if LL B1 is empty it should display FEES D1.

I hope this makes sense I have tried to explain it as best I can! Thank you again!! I just wish i could work this out myself!

I THINK I CRACKED IT!!!! i think i have done it... =IF(B2="LL MATCH",IF(VLOOKUP(E2,Sheet2!$A$2:$B$3000,2,FALSE)=0,D2,VLOOKUP(E2,Sheet2!$A$2:$B$3000,2,FALSE)),"")

 

[Smitty]

I left out the qualifier for the first VLOOKUP:

=IF(B20="LL MATCH",IF(VLOOKUP(L20,LL!$A$2:$B$3000,2,FALSE)="",'FEES-BATCHED'!E20,VLOOKUP(L20,LL!$A$2:$B$3000,2,FALSE)),"")

OR

=IF(B20="LL MATCH",IF(VLOOKUP(L20,LL!$A$2:$B$3000,2,FALSE)=0,'FEES-BATCHED'!E20,VLOOKUP(L20,LL!$A$2:$B$3000,2,FALSE)),"")

EDIT: I just saw your post - glad you figured it out.

 

[INEEDEXCELHELP]

I left out the qualifier for the first VLOOKUP:

=IF(B20="LL MATCH",IF(VLOOKUP(L20,LL!$A$2:$B$3000,2,FALSE)="",'FEES-BATCHED'!E20,VLOOKUP(L20,LL!$A$2:$B$3000,2,FALSE)),"")

OR

=IF(B20="LL MATCH",IF(VLOOKUP(L20,LL!$A$2:$B$3000,2,FALSE)=0,'FEES-BATCHED'!E20,VLOOKUP(L20,LL!$A$2:$B$3000,2,FALSE)),"")

EDIT: I just saw your post - glad you figured it out.

Thank you very much for your help!!