Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 31st 04, 12:55 PM
CCDC
 
Posts: n/a
Default Lookup, IF, Then help

Below is the basic format of the 4 columns - In the 5th column (E) I want to
write a function where if the value in column A matches colmn C then the
return is the value in Column D - SO in the Row beginning in F it would go up
to the first C and see an H and pass it look at the next row and see an H
etc, then get to the second row and see the F and return the value 3 (which
is the sum of the F's)
A 1 F
A 2 F 3
B 3 G 3
C 5 H
C 2 H
C 1 H
C 1 H 9
D
E
F

I tried LookUP but it didn't always return an exact match. If the 3rd
column were dates and the column A date was Jun 16, once the array got to Jun
17 in Column C it returned that value, instead of going one more for the
exact match

--
- CC

  #2   Report Post  
Old October 31st 04, 01:33 PM
CCDC
 
Posts: n/a
Default

I am using this - =LOOKUP(A15,C4:C15,D415) --- It works, except it returns
close matches and exact matches - I only want the exact ones.

"CCDC" wrote:

Below is the basic format of the 4 columns - In the 5th column (E) I want to
write a function where if the value in column A matches colmn C then the
return is the value in Column D - SO in the Row beginning in F it would go up
to the first C and see an H and pass it look at the next row and see an H
etc, then get to the second row and see the F and return the value 3 (which
is the sum of the F's)
A 1 F
A 2 F 3
B 3 G 3
C 5 H
C 2 H
C 1 H
C 1 H 9
D
E
F

I tried LookUP but it didn't always return an exact match. If the 3rd
column were dates and the column A date was Jun 16, once the array got to Jun
17 in Column C it returned that value, instead of going one more for the
exact match

--
- CC



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I lookup and return different values when the lookup value. kg Excel Discussion (Misc queries) 1 January 20th 05 12:53 AM
How to lookup data in a row and column Confused Excel Discussion (Misc queries) 5 January 10th 05 08:20 PM
need check two worksheets to lookup a value Clay Excel Discussion (Misc queries) 2 January 5th 05 08:35 AM
HELP -- probably a LOOKUP problem Liz-In-USA Excel Discussion (Misc queries) 3 December 9th 04 12:18 AM
double lookup, nest, or macro? Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM


All times are GMT +1. The time now is 06:26 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017