I want If and Vlookup together in one cell

[Safi.]

Hi,

I have to enter cheque no. in control find to find in say Sheet 1(my data)
to get the Loan Agreement No. the problem is that it i did not have any
record of how many cheque I got or I entered on that date.

I want to enter cheque no. in a new sheet in column A Can I get the
Agreement No. of the cust in the column B.. from my data sheet which has 3
cheques no in three columns respectively..
Is this possible that among these 3 columns my cheque entry in column A
matches
with it and return the Loan Agr No which is in the fourth column next to the
cheque details.

Thanks,
Safi

 

[Bob Phillips]

=IF(ISNA(VLOOKUP(A2,Sheet1!A,4,FALSE),"",VLOOKUP(A2,Sheet1!A,4,FALSE))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Safi.]

Hi Bob,

the below mentioned formula gives error msg at "". wat to do,
further the cheques no. are in three columns can it be an array to search
and get the next column value if my entry matches with any one from the
three. u can give some alternate formulas also.

Thanks,
Safi.