Need help im multiple if conditions in excel
Hi,
I have a sheet in which column A contains some data and column b contains dates corresponding which are different from each other
I am using a formula with if condition for a range lookup and return the corresponding date.
the formula is
I am not getting successfull result. Please help me.=IF(I5=A3:A8,B3,0)
What i need is if i enter the data in I5 then I want the corresponding date in I6.
Like that i have around 3000 entries. Can any one help me in getting data with if condition
Attaching the file for testing also
Last edited by kishoremcp; 02-12-2012 at 05:38 AM.
That will check for the value in I5 in the specified table (A3:B8) and if found return the value in column 2. If the value from I5 is NOT found in the table, it will return the error "FALSE."=VLOOKUP(I5,A3:B8,2,FALSE)
Last edited by CapnSef; 02-11-2012 at 11:56 AM.
Hi
Have you tried the VLookup function instead of the if function
put this in Cell I6
James=vlookup(I5,A1:B3000,1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks