hi,
I have a formula v lookup long enough
the example below would be longer if there are hundreds of data varies in column b
is there any way faster than making namebox one by one
IF(ISNA(I11*VLOOKUP(H11,CAR,3,FALSE)),"",I11*VLOOKUP(H11,CAR,3,FALSE))
thanks
regards
Last edited by herukuncahyono; 02-12-2015 at 12:27 AM.
how bout the attached?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Try this version.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Put in J11:
=IFERROR(LOOKUP(2,1/(($A$2:$A$5=$H11)*($B$2:$B$5=J$10)),$C$2:$C$5),"")
and copied cross and down
cheers
hi, humdingaling
thanks for the help, this is what I mean
many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks